That did a great job of de-duping the list for me, but it only returned the values from a single entry per name. For example, I have Bob Smith listed twice, once with an e-mail address and once with a mailing address. The VLookup apparently only looked until it found the first entry for Bob Smith, and only returned the e-mail address.

How do I make the VLookup compile data from multiple rows?


[quote=N Harkawat]I would make a unique list of all first and last names using Data
Filter -Advanced filter --Unique
in a separate part of your w/sheet

Then do Vlookup for individual categories to go right next to the list that
you created above.