Reply To: Index Match and Converting to a Column Formula

Louise,
I’m unsure of your exact use case, but You can do this by using another column for the first and last names. I created a quick video to show what I came up with. This doesn’t ensure that you get the latest entry should there be multiple, but it gives you the first previous entry that matches the Person ID.

I’m not checking for blanks in the collect range, so that might be something you want to consider in case you have more than 1 matching person ID that has a blank last name.

Here’s the video. Let me know if that works!