|
|
|
|
| Author |
|
|
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 |
||
11-20-2008, 10:34 AM
|
|
|
Registered
|
How about.. (B1 is list cell)
=if(B1="premium",150,130) Or, are you referring to a VB combo box?
__________________
84 944 Last edited by anotherblack944; 11-20-2008 at 10:58 AM.. |
||
|
11-20-2008, 10:54 AM
|
|
|
Custom User Title
Join Date: Oct 2002
Location: Miami
Posts: 4,294
|
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. |
||
|
11-20-2008, 11:21 AM
|
|
|
Registered
Join Date: Nov 2003
Location: Northern Ireland.
Posts: 102
|
Thanks guys, we're sorted.
__________________
E30 318i ................. Gone. E36 325 tds ............. Gone. E39 525d ................. Gone. E39 535i .................. Resting Panamera 3.0 diesel ... Daily driver |
||
|
11-21-2008, 12:46 AM
|
|
2015 
