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