Compare Two Columns (from two different worksheets) and show result of another column - excel

Question

I have this scenario:

I have to compare Column A (Worksheet 1) and Column A (Worksheet 2).

If a value in Column A (Worksheet 1) is existing in Column A (Worksheet 2), it must show the value in Column B (Worksheet 2).

Please help. I have been trying to do this. I can only compare the Column A of both worksheets but I cannot show the Column B.

What "value" are you looking to place in column B of Sheet2? If you are looking for duplicates, you just want to list the name in column B if it's found in Sheet1?

Excellll · Answer 1 · 2011-08-15 13:28:41Z

up vote 4 down vote

This sounds like you just need a simple VLOOKUP formula.

=VLOOKUP(Sheet1!A2,Sheet2!A1:B20,2,FALSE)

where A2 is the value on Sheet 1 you want to look up, and A1:B20 is the entire table on Sheet2.

answered Aug 15 '11 at 13:28

Excellll
2,998621

random · Answer 2 · 2011-08-20 18:30:31Z

up vote -1 down vote

Use a simple IF formula instead.

In cell B1 enter:

=IF(sheet1!$A1=sheet2!$A1,$A1)

and copy down as far as you need to go.

edited Aug 20 '11 at 18:30

random♦
6,29532746

answered Aug 20 '11 at 17:56

Sleette
11

migrated from stackoverflow.com Aug 15 '11 at 19:02