Good morning.
I am hoping you can help me with a formula I am struggling with. I am creating a cost calculator to make my clients lives a little easier. An example of what I need would be as follows:
I have a data validation list for the client to choose their entertainment requirements the list it cell links to is:
Please Select
None £0.00
Pianist £150.00
Disco £275.00
Murder Mystery £550.00
Two Table Casino £450.00
Three Table Casino £600.00
Three Piece Band £650.00
Four Piece Band £800.00
Five Piece Band £950.00
Each of these items has a cash value that I have listed in the adjacent cell to the list. I need excel to recognize that when they choose Disco (for example) the results cell will show £275.00. I have tried using MATCH and IF functions but cannot work out how to do it.
I apologise that my first post is asking for help but any assistance you can provide would be greatly appreciated. I am more than happy to email the spreadsheet for you to play with if that helps (attached)
Bookmarks