Help with remove #N/A error from IF & VLOOKUP statements

[Rahuluk]

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

§

 

[mrshl9898]

If you want to change the N/A to something else, just use =IFERROR(your formula here,"") to change it to blank or change the "" to whatever value you want returned.