vlookup

  • Thread starter Thread starter albertmb
  • Start date Start date
A

albertmb

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
 
Use an ISNA error trap, eg:
=IF(ISNA(vlookup(..)),0,vlookup(..))
which returns zero for unmatched cases
Adapt the return to suit
 
Thank you Max, it worked perfectly.

Max said:
Use an ISNA error trap, eg:
=IF(ISNA(vlookup(..)),0,vlookup(..))
which returns zero for unmatched cases
Adapt the return to suit
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP formula displays in cell, will not return data 1
Deleting #NA in a Spreadsheet 5
Involved VLookup Function 6
Vlookup with Pivot Table 1
How do I set up the percentage correctly in this spreadsheet? 1
PIvot Tables 2003 and VLookup 5
countif and Vlookup 2
IF function inequality is not calculating correct result 6

Back
Top