Removing #N/A error from IF & VLOOKUP formulas

Hi all,


I have a formula on my spreadsheet shown in RED, which is essentially a VLOOKUP statement however, it is making an exception to one of the lookup values, whereby if the lookup value is set to EBY PROMO then the calculation performed after VLOOKUP remains capped at 1.00. Whereas the other look up values will have the calculation performed and retrieve the expect figure.


The formula is working overall. However, when there is no lookup value selected a #N/A error appear, which is rather annoying and it also affect other cells if there is a formula containing these cells containing the NA error in the formula.


See attached image.


I'd be grateful if someone can help shed some light on this issue.


Many thanks

You can enclose your formula with an IFERROR(formula,"") like this so that your value is blank when there is no source.