Not showing #N/A
 

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

Not showing #N/A
 

Just trap it with an IF(ISNA(...) construct, indicatively like this:
=IF(ISNA(vlookup(...)),"",vlookup(...))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rexmann" wrote:
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

Not showing #N/A
 

Hi Max

Job done, thank you

Cheers Rexmann

"Max" wrote:

Just trap it with an IF(ISNA(...) construct, indicatively like this:
=IF(ISNA(vlookup(...)),"",vlookup(...))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rexmann" wrote:
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

Not showing #N/A
 

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.
--
David Biddulph

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

"rexmann" wrote:
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

Not showing #N/A
 

Welcome, Rexmann
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rexmann" wrote in message
...
Hi Max
Job done, thank you
Cheers Rexmann