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.