Really appreciate your help. I have unique IDs for each person, but there are multiple rows for certain people who obviously will have the same ID. How do I get the lookup values in the VLOOKUP to match the IDs with multiple occurrences. I believe I have to use an index/match function, but I'm not quite sure how to use it. I've attached an example.
Solved by D. D. in 28 mins