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!