Help with IF and VLookup Match Statement
 

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!

Help with IF and VLookup Match Statement
 

=if(iserror(vlookup(.....)),"na",vlookup(...))


On Feb 11, 2:46*am, JessM wrote:
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!