• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

MS Excel 2007 Help

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
Curtis Long
Asked:
Curtis Long
  • 2
1 Solution
 
dlmilleCommented:
Here you go...

Dave
ThisThatTheOther-r1.xlsx
0
 
dlmilleCommented:
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
 
Curtis LongAuthor Commented:
Beautiful!!  :-)

Thank you SO much!!  :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now