vlookup puzzle

  • 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.
 
Please post your formula, the input values, whether your table was sorted, the reply you expected and what you got instead.

We're not clairvoyant!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.
|
 
You probably need to include the last option in the VLOOKUP formula........

=VLOOKUP(A1,MYTABLE,2,FALSE)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top