R
RFJ
I've got a vlookup table that, correctly, returns #N/A because a value is
missing.
I want to replace the #N/A with a blank cell but can't get the syntax right.
In excel/english what I want to achieve is :
if(vlookup table returns "#N/A" replace with "", else show value returned by
vlookup table)
TIA
missing.
I want to replace the #N/A with a blank cell but can't get the syntax right.
In excel/english what I want to achieve is :
if(vlookup table returns "#N/A" replace with "", else show value returned by
vlookup table)
TIA