Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the result is not possible?
T tbrownusa Feb 9, 2009 #1 Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the result is not possible?
F Fred Smith Feb 9, 2009 #2 The standard was is: =if(isna(vlookup(....)),"",vlookup(.....)) If you have XL2007, you can use: =iferror(vlookup(....),"") Regards, Fred.
The standard was is: =if(isna(vlookup(....)),"",vlookup(.....)) If you have XL2007, you can use: =iferror(vlookup(....),"") Regards, Fred.
