vlookup puzzle
 

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.

vlookup puzzle
 

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

"lloyd" wrote in message ...
|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.
|

vlookup puzzle
 

You probably need to include the last option in the VLOOKUP formula........

=VLOOKUP(A1,MYTABLE,2,FALSE)

Vaya con Dios,
Chuck, CABGx3



"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.

vlookup puzzle
 

Go back to your original posting to see some responses


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 11:09:02 -0800, 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.