Not showing #N/A

R

rexmann

Hi

Is there a way to set the excel column so it does not display the #N/A

I have a spreadsheet with a V-look up ready to calculate when the user
enters the details but until this happens it comes up with a little green
triangle and a #N/A - where I want it to remain blank

Any suggestions greatly appreciated
 
M

Max

Just trap it with an IF(ISNA(...) construct, indicatively like this:
=IF(ISNA(vlookup(...)),"",vlookup(...))
 
R

rexmann

Hi Max

Job done, thank you

Cheers Rexmann

Max said:
Just trap it with an IF(ISNA(...) construct, indicatively like this:
=IF(ISNA(vlookup(...)),"",vlookup(...))
Click to expand...
 
D

David Biddulph

An alternative is to use Conditional Formatting to change the font colour to
white (or the background colour) if the cell satisfies the ISNA() condition.
 
Top