To be absolutely sure your values match, you should be able to copy one and
replace the other (supposed) match with it (or just type the same value into
both cells), and see if it works now. If it DOES, then likely, one of your
lists has spaces in the values somehow.
************
Anne Troy
www.OfficeArticles.com

"Rose Davis" wrote in message
...
I have only 2 worksheets in column A is the item # which sometimes has a
letter associated with it as in 815NB in column B is the desctiption. This
formula works fine when the cell only contains a number but will not
including the letter. I can manually retype the cell info and the formula
will find it even with the letter association. Worksheet 1 has 14000 rows
and Worksheet 2 has 3000 rows, so I only need some of the information from
the 1st worksheet. The formula I'm using is
=IF(ISNA(VLOOKUP(A1,LKF!A:B,2,
FALSE)), "", VLOOKUP(A1,LKF!A:B,2, FALSE)) Sorry for the length. I also
tried to change text numbers to numbers and this did not work either.
Thanks for any assistance