98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Drop down lists
Drop down lists
Resolved · Urgent Priority · Version 2007
Thu 17 Nov 2011, 12:57Delegate Gurdeep said...
Gurdeep has attended:
Excel Advanced course
Drop down lists
Is there a way to combine an if function with a drop down list?
Thu 17 Nov 2011, 15:58Trainer Paul said...
RE: Drop down lists
not without using VB. Can you please explain why you want to do that and I will be able to help more?
Thanks
Paul
Fri 18 Nov 2011, 10:05Delegate Gurdeep said...
RE: Drop down lists
Hi Paul
I have created a drop down list.
I want to create a merge a drop down list with an IF statement.
For eg:
If the left colum contains a yes then this colum is o otherwise choose from the drop down list.
Colmn A Colm B
Yes =if(A1="Y", then pick from drop down list otherwise 0.)
Can that be done in excel?
Thanks
Gurdeep
Mon 21 Nov 2011, 13:42Trainer Paul said...
RE: Drop down lists
=if(A1="Y", 0,false)
you would put your combo box in false. this cant be dont without VB coding being written. Nice idea though ;) a nested if function would be your next best thing.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using an equal (=) sign that isn't part of a formulaBefore you type the equal sign, type an apostrophe: ' |
