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.