I use Vlookup and when the took up table does not have the value it returns error #N/A. How can I read this. I mean ifit returns #N/A i would like some variable to have value =" not found" else "found". Something like

Check_Vlookup = IIF(VLOOKUP(..,..,..)="#N/A", "Not Found", "Found").

Obviously this does not work. Though the formula result shows "#N/A" in the cell it is not equal to string "#N/A".

Please help