vlookup

  • Thread starter Thread starter lloyd
  • Start date Start date
L

lloyd

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.
 
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)
 
I have false in the correct position


JE McGimpsey said:
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)
Click to expand...
 
Then please provide some examples of your data (in a message, not an
attachment), along with your formula(e), that illustrates the problem.
 
Are both the vlookup table, and the cell you are looking at of the same
format? Just a thought.
 
Just doubled check and to it's ok. to be sure I copied the format from one to
the other.
 
Post your formula and a sample of 12-digit numbers.

Also, how are the 12-digit numbers produced?


Gord Dibben MS Excel MVP
 
lloyd said:
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.
Click to expand...

I don't know so well, but is your table sorted an ascending order?

JG
 
Back
Top