Compare two different lists for matches with the result being corresponding data from another cell?

Question

Compare two different lists for matches with the result being corresponding data from another cell?

Anonymous

I've copied and pasted 2 large data sets into one spreadsheet with customer account information. I want to compare two columns for common account numbers, with the result being that if there's a match, it pulls the corresponding email from another cell that is in-line with the email corresponding to the matching account number. Is this possible?

Here's an example of what I mean. Hope this helps.

Account number 1	Account number 2	Corresponding client email 1	If Acct1=Acct4, then client email 2 here
Account number 3	Account number 4	Corresponding client email 2	If Acct3=Acct2, then client email 1 here
Account number 5	Account number 6	Corresponding email 3	If Acct5=Acct6, then client email 3 here
And so on...

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

I guess you want to get Corresponding Email from another sheet.

Change E2 to the cell you want to find.

=VLOOKUP(Sheet1!E2,Sheet1!A:B,2,0)

If my understanding above is not consistent with yours, share some dummy data and expected result more clearly or a test file.

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Share via

Compare two different lists for matches with the result being corresponding data from another cell?

1 answer