vlookup
Steve, Marcelo's answer will work very well. However, if you want to be very
specific for the #NA error only, you can us
=IF(ISNA(VLOOKUP(formula),"",VLOOKUP(formula))) instead. This would catch
#NA errors only, but if something else is wrong, then that would try to
return the true case which might show another error such as #VALUE.
"Marcelo" wrote:
hi Steve,
use IF(ISERROR(VLOOKUP(your formula here),"",VLOOKUP(you formula here)
please adjust the "(" as necessary
hope this helps
regards from Brazil
Marcelo
"Steve" escreveu:
I have a column containing a vlookup formula. With blank rows vlookup returns
#N/A. To handle those situations I would like to put the vlookup formula
inside an 'if' statement that returned a value other than #N/A;ie,
If(vlookup()= "#N/A" ,0,Vlookup(....) )". However, using "#N/A" as the
condition doesn't seem to work-is there something else that does?
|