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