G
Guest
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?
#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?