Vlookup formula where lookup value is a result a formula (receive.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Vlookup formula where lookup value is a result a formula (receive #N/A error)
How fix?
 
Without seeing what your formula is, it's impossible to do more than
guess...
 
Maybe:

=if(iserror(vlookup(...)),"some error message",vlookup(...))

or maybe...

=if(isna(a1),"",vlookup(a1,sheet2!a:e,3,false))
 
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

Use formula result in vlookup 1
Formula not working 4
VLOOKUP just returns formula 1
"#N/A" Result From VLOOKUP Formula 3
VLookup returning #N/A when looking up a cell that has a Formula i 3
How do I use a formula result in another formula 2
VLookup 1
VLookUP formula help! 5

Back
Top