Posted to microsoft.public.excel.worksheet.functions
|
|
vlookup
Are both the vlookup table, and the cell you are looking at of the same
format? Just a thought.
--
Best Regards,
Luke M
"lloyd" wrote:
I am new to this so just checking to see if this was received
"lloyd" wrote:
When I do text formatting it appearing as 12452145E12
"Don Guillett" wrote:
Above 9 try formatting as text
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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.
|