No spaces before or after. I have tried copying the part number from
spreadsheet B and inserting it into spreadsheet A to make sure the number are
identical. Still will not return the description. Also, if I insert a new
line in spreadsheet B and enter a new part number and description, then try
to recall this in spreadsheet A, it still will not find that new part number
description.

Dan

"Jacob Skaria" wrote:

OK. Check whether you are having a space before or after ":CFF-8" in cell $A53.


Inorder to handle the additional : in your lookup table you can adjust the
vlookup to the below...which will lookup "CFF-8" and return the results for
":CFF-8" ....

=VLOOKUP("*" & TRIM($A53) & "*",Sheet2!A:B,2,0)

If this post helps click Yes
---------------
Jacob Skaria