Nested IF statements that involve #N/A errors from vlookups

**CorporateBatteryHen** · 07-02-2013, 01:41 AM

Hi,

I have a spreadsheet that looks up a product and returns an associated dollar discount value. There are 3 possible outcomes of the lookup. The product is not on the discount list and so returns an #N/A error. The product is on the discount list and returns a discount value greater than zero The product is on the discount list but the value of the discount is zero.

Depending on the result of the lookup I want a nested if formula that inserts a designated narration in another separate column. I've made some headway but I've no idea how to handle the #N/A errors that come up. An example of what I want is in the attached file.

Thank you!Book2.xlsx

**benishiryo** · 07-02-2013, 01:54 AM

hi there, welcome to the forum. perhaps you should do this for your VLOOKUP formulas for it to look neater:
=IFERROR(VLOOKUP formula,"")
then in C2:
=IF(B2="","Not in Discount List",IF(B2>0,"Yes","NO - Zero Discount"))

if you want to keep the N/A there, then in C2:
=IF(ISNA(B2),"Not in Discount List",IF(B2>0,"Yes","NO - Zero Discount"))