Extract matching records

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Have you looked into use of VLOOKUP