Post your formula and a sample of 12-digit numbers.

Also, how are the 12-digit numbers produced?


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 09:54:04 -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.