Match Columns

[saucey]

Hi, I have two tabs in excel, one is labeled 'Parts' and the other is labeled 'ReferenceParts'. 'ReferenceParts' has an assembly number column with an assembly description. Parts has one column that only has an assembly number column, and an empty assembly description column. How can I match up a description from 'ReferenceParts' to 'Parts'? I've tried using VLOOKUP and MATCH, but I may be doing it incorrectly. I've attached the file for your viewing purposes.

[Pete_UK]

Put this formula in B2 of the Parts sheet:

=IFERROR(VLOOKUP(A2,ReferenceParts!A:B,2,0),"")

and then copy down by double-clicking the fill handle with B2 selected (the small black square in the bottom right corner of the cursor).

Hope this helps.

Pete

[stanleydgromjr]

saucey,

Copy the following formula into worksheet Parts, cell B2, then copy down in column B to the last used cell in column A:

=IF(ISNA(VLOOKUP(A2,ReferenceParts!A:B,2,FALSE)),"",VLOOKUP(A2,ReferenceParts!A:B,2,FALSE))

[saucey]

Both work great! Thanks gentlemen!

[stanleydgromjr]

saucey,

Thanks for the feedback.

You are very welcome. Glad we could help.

Come back anytime.