Excel Help Needed

[bowers01 +]

Hi,
For my school project i have to make a excel spread sheet for a made up client that is strugling with quotes. We need to make it easy for the user to do it over the phone. The company supplies party meals/food and drink.
I have attached an extract of the spread sheet, this is the bit thats causing me problems.
If you select and item from the dropdown menu(Next to type of meal)
You will see 4 options: Please select, Finger Food, Chicken and Steak.
Once you select one the price will show up next to it.
The prices of meal is to the right of all this.

If you select "Please select" it should show up "1" but it actually shows up 15. The Finger Food is fine, but if you pick "Chicken" it shows "#N/A" but the "Steack" Works fine.
Could some please tell me why the finger food and steak work but please select and chicken do not? They all use the same formula.

Thanks,
Nick