Formula Help - Trying to display £0.00

[johnrobgray]

Hi guys

I’m working on a sales tracker for work
I’ve it a formula for a cell that when an option is picked from a drop down menu it displays a price

However when no option is picked it currently displays #N/A and this is stopping my formula from calculating

How can I get it to display a £0.00 if nothing is selected

The formula currently reads

=VLOOKUP(I10,Y18:AA32,3,FALSE)

Totally thankful in advance

 

[arthurbr]

Perhaps =IFERROR(VLOOKUP(I10,Y18:AA32,3,FALSE),0)

Or use IF( ISERROR... for pre 2007 versions

 

[johnrobgray]

Worked a treat! Thank you so much!