vlookup
 

Hi everyone,

Once again I need your help, and I thank you in anticipation for your kind
help and support.

I am using a vlookup formula to get results from sheet 2 to sheet 1. When
the result is not available I get #NA by default. My problem is that in this
occasion I know that I should not get a result, is there a posibility to
eliminate the #NA from the cell, or maybe change it to a 0. I know that I
can use conditional formatting and maybe change font to white, but I need to
export this sheet into another system and I think it will not be able to
recognise the #NA.

Thank you

Albert

vlookup
 

Use an ISNA error trap, eg:
=IF(ISNA(vlookup(..)),0,vlookup(..))
which returns zero for unmatched cases
Adapt the return to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"albertmb" wrote:
Hi everyone,

Once again I need your help, and I thank you in anticipation for your kind
help and support.

I am using a vlookup formula to get results from sheet 2 to sheet 1. When
the result is not available I get #NA by default. My problem is that in this
occasion I know that I should not get a result, is there a posibility to
eliminate the #NA from the cell, or maybe change it to a 0. I know that I
can use conditional formatting and maybe change font to white, but I need to
export this sheet into another system and I think it will not be able to
recognise the #NA.

Thank you

Albert

vlookup
 

Thank you Max, it worked perfectly.

"Max" wrote:

Use an ISNA error trap, eg:
=IF(ISNA(vlookup(..)),0,vlookup(..))
which returns zero for unmatched cases
Adapt the return to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"albertmb" wrote:
Hi everyone,

Once again I need your help, and I thank you in anticipation for your kind
help and support.

I am using a vlookup formula to get results from sheet 2 to sheet 1. When
the result is not available I get #NA by default. My problem is that in this
occasion I know that I should not get a result, is there a posibility to
eliminate the #NA from the cell, or maybe change it to a 0. I know that I
can use conditional formatting and maybe change font to white, but I need to
export this sheet into another system and I think it will not be able to
recognise the #NA.

Thank you

Albert

vlookup
 

Welcome, good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"albertmb" wrote in message
...
Thank you Max, it worked perfectly.