|
Registered
Join Date: Nov 2003
Location: Northern Ireland.
Posts: 102
|
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
__________________
E30 318i ................. Gone.
E36 325 tds ............. Gone.
E39 525d ................. Gone.
E39 535i .................. Resting
Panamera 3.0 diesel ... Daily driver
|