Match 2 Columns and Popluate Another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am in desperate help.

I have a spreadsheet with 2 tabs. Both tabs have item ID's in the first
column. The second columns contain different data. I need to match the
items in the first column on the first tab to the first column on the second
tab, and if they match retrieve the information from the second tab, second
column to be placed on the first tab, third column.

Thank you.
 
One way

Assume data starts in row2 down

In Sheet1,

Put in C2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!B:B,MATCH(A2,Sheet2!A:A,0)))
Copy down as far as required
 
Back
Top