VLOOKUP error

[firstWeMeet]

My error is
E9=IF(C9="","",VLOOKUP(C9,TABLE1,7,0)) then it show #N/A, this error happen when the C9 is not mentioned at the TABLE1, but what I want is, even the C9 is not included at the table, the E9 should show a blank cell instead of the #N/A. can someone fix this? thanks

 

[prajul89]

Try ISNA along with IF statement or Just use IFERROR if you are using 2007

=IFERROR(VLOOKUP(C9,TABLE1,7,0),"")

 

[Michael M]

Try

=IF(C9="","",IF(ISNA(VLOOKUP(C9,TABLE1,7,0)),"",VLOOKUP(C9,TABLE1,7,0)))