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

  • Thread starter Thread starter CMAXWELL
  • Start date Start date
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?
 
Multiply the outcome by 1 something like:

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

hth
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas #N/A 4
Alternative for Vlookup output of #N/A if data not found? 4
Combo Box - How to Use Output in Vlookup 4
VLOOKUP Irk 1
VLOOKUP returning #N/A result 2
working with #N/A and conditional formating 1
Can't Explain N/A in Vlookup 2
help on a vlookup please 5

Back
Top