VLookup

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

Guest

I am trying to do a vlook up on a table of data. The table of data is based
on another formula so the value that is being searched for is formula based
which is returning a #N/A value, can i get around this??
 
April said:
I am trying to do a vlook up on a table of data. The table of data is
based
on another formula so the value that is being searched for is formula
based
which is returning a #N/A value, can i get around this??
Click to expand...

April

One way, if I have understood you correctly:

=IF(ISERROR(your lookup formula), "Does not exist", your lookup formula)
 
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

Excel 2002: Return blank when VLOOKUP on blank cells 2
VLOOKUP returning #N/A result 2
VLookup in Excel 2007 - question on setup 2
VLOOUP 2
v look up and rounding 2
VLookup returning #N/A when looking up a cell that has a Formula i 3
Sumproduct formula 3
Vlookup and Trace Return Cell 2

Back
Top