answer:The Vlookup function is what you seek. Example: Book1 has a list of part numbers 1 2 3 4 5 Book2 has a list of part numbers,with product name 4 tchotchke 2 gizmo 5 trinket 3 thingy 1 doodad Here’s the formula for Book1 (cell B1) to lookup the product name from Book2 =VLOOKUP(A1,[Book2.xlsx]Sheet1!$A:$B,2,FALSE) The part numbers do not have to be in any particular order on either sheet. (if you use that FALSE argument at the end).