**News Alert:**Experts Exchange Confirmed as Safe in Cloudbleed Leak Read More

Solved

Posted on 2013-12-16

Is it possible to make my IF statement return a 0 instead of N/A where I am using several IF statements?

=IF(E9=8455,VLOOKUP(Sheet1!G9,'8455'!A:B,2,0),IF(E9=8456,VLOOKUP(Sheet1!G9,'8456'!A:B,2,0),IF(E9=8457,VLOOKUP(Sheet1!G9,'8457'!A:B,2,0))))

Thanks

=IF(E9=8455,VLOOKUP(Sheet1

Thanks

2 Comments

=IFERROR(IF(E9=8455,VLOOKU

That will work in newer versions of excel. If you have an older one, you could use =IF(ISERROR(IF(E9=8455,VLO

Matt

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join the community of 500,000 technology professionals and ask your questions.