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