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?


N Harkawat Wrote:
> 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.


--
joe peters