[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MS Excel 2007 Help

Posted on 2011-05-07
3
Medium Priority
?
295 Views
Last Modified: 2012-05-11
I need to have a drop down list that has the following things:

This
That
the other

I know how to do that.  :-)

Next I need to have the following:

If "This" is selected from the drop down list, a1 thru 3 dispalys the following

a1 123
a2 456
a3 789

If "That" is selected from the drop down list, a1 thru 3 displays the following

a1 abc
a2 def
a3 ghi

If "the other" is selected from the drop down list, a1 thru 3 displays the following

a1 123abc
a2 456def
a3 789ghi

Is there a way to accomplish this??
0
Comment
Question by:Curtis Long
  • 2
3 Comments
 
LVL 42

Expert Comment

by:dlmille
ID: 35713912
Here you go...

Dave
ThisThatTheOther-r1.xlsx
0
 
LVL 42

Accepted Solution

by:
dlmille earned 2000 total points
ID: 35713918
Note, the formula in A1 - looks at the drop down list result in C1:

=IF($C$1="This","123",IF($C$1="That","abc",IF($C$1="the other","123abc","")))

Then for A2, and A3, the results are slightly different, as requested..

A2:
=IF($C$1="This","456",IF($C$1="That","def",IF($C$1="the other","456def","")))

and A3:
=IF($C$1="This","789",IF($C$1="That","ghi",IF($C$1="the other","789ghi","")))

Enjoy!

Dave
0
 

Author Closing Comment

by:Curtis Long
ID: 35714009
Beautiful!!  :-)

Thank you SO much!!  :-)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question