Extract matching records

Closed
Kathy - 5 Jul 2010 à 17:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Jul 2010 à 19:07
Hello,

I have 2 excel sheets. One has email addresses and additional contact information in it. The second is a subset of the emails addresses and only has email information.

I want to retrieve all information in the row when email addresses match in both lists.

Any help is appreciated!


1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
6 Jul 2010 à 19:07
Have you looked into use of VLOOKUP