Help with IF and VLookup Match Statement

J

JessM

I am trying to write an if statement that if a value in the lookup table does
not exist to return a NA instead of an #N/A Error. If the value does exist in
the table than return that value.


Here is my formula that isn't quite working. I am having trouble with the IF
and ISERROR

=IF(VLOOKUP(X$5,Meeting_Planner_Towers_Final.xls!$C:$ED,MATCH($B10,Meeting_Planner_Towers_Final.xls!$C$1:$ED$1,0),FALSE))=(ISERROR(X10)),"NA",(VLOOKUP(X$5,Meeting_Planner_Towers_Final.xls!$C:$ED,MATCH($B10,Meeting_Planner_Towers_Final.xls!$C$1:$ED$1,0),FALSE).

Any help is greatly appreciated!
 

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

Help with Vlookup Match and IF statement 2
Help with If and Vlookup Statement 1
Vlookup and If statement help 1
Vlookups to return a N/A value 3
Help With VLOOKUP 2
Index Match function for lookup HELP 5
VLOOKUP & Data Validation 0
Finding dynamic maxima 9

Top