Excel help, please!
 

Guys, I’m trying to help my son out with a combo box in Excel – but failing miserably, so I need your help.
He needs to return one of two prices in an adjacent cell, depending on what is selected from the drop-down list. So let’s say he wants £130 in the adjacent cell if “standard” is chosen, and £150 in the cell if “premium” is chosen.
I have “standard” and “premium” on the sheet so as I can have them for the input range, but I’m confused with what formula I need to use to get the correct value returned. TIA.
Stephen

How about.. (B1 is list cell)

=if(B1="premium",150,130)

Or, are you referring to a VB combo box?

Send it to me if you haven't figured it out yet- its a lot easier for me if I can see it.

I Pmed you my email.

Thanks guys, we're sorted.