vlookup: data same in 2 tabs yet get #N/A when shouldn't

C

CMAXWELL

I know there must be a reason that data/number not recognized, but changing
formatting doesn't help - would have to retype numbers to get vlookup to
recognize. Any quick fixes?
 
M

Maurice

Multiply the outcome by 1 something like:

Vlookup(lookupvalue,tablerange,column,false)*1

hth
 
Top