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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Shazam" wrote:
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.