Take a look at VLOOKUP In XL Help, you need to set the range_lookup
argument to FALSE, e.g.:

=VLOOKUP(A1,J:K,2,FALSE)

In article ,
lloyd wrote:

I have a 12 digit number in one area and doing the vlookup seems to be only
looking at the first 6 and rouding at that point. I need the lookup to look
at the entire 12 characters and do a match on all 12.