how to search between two workbooks

[leebre]

Hi guys, thanks for the help on the last one. I have my total parts inventory created and now would like to cross reference between another workbook that has descriptions according to part number. Here is a sample of what i want to do:

book1 book2
Part number Part number Description
FC9520TMX1 FC9520TMX1 Transmux



book2 has all avaliable equipment from the manufacture.
book1 has only that which I currently stock.
I would like to port the description from book2 into book1

hope this is clear.

 

[ravishankar]

Hi
in book1 col B insert the formula
B1=vlookup(A1,[book2.xls]sheet1!A1:B100,2,false)
drag it till the end of data
RAvi