Not showing #N/A

[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

 

[Max]

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

 

[rexmann]

Hi Max

Job done, thank you

Cheers Rexmann

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

 

[Max]

Welcome, Rexmann