--Have you tried the below version
=VLOOKUP("*" & TRIM($A53) & "*",Sheet2!A:B,2,0)

--I am sure this is something simple which we are unable to track. Check
your named range; Copy paste a small set of data to another workbook and try
out sample VLOOKUPS() to find whats happening..

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


"dannaz" wrote:

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