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
|