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