I am making a drop down menu...
Lets say the choices a
choice 1: a b c d
choice 2: e f g h
choice 3: i j k l

i want to make it that if choice 1 is selected, only "a" is displayed
(not a b c d).
if choice 2 is selected, only "e" would be displayed (not e f g h)
etc...

is this possible??

please email me with a solution!

thanks!


--
jacke613
------------------------------------------------------------------------
jacke613's Profile: http://www.excelforum.com/member.php...o&userid=18581
View this thread: http://www.excelforum.com/showthread...hreadid=383157

How about just using a helper cell:

=left(a1,1)




jacke613 wrote:

I am making a drop down menu...
Lets say the choices a
choice 1: a b c d
choice 2: e f g h
choice 3: i j k l

i want to make it that if choice 1 is selected, only "a" is displayed
(not a b c d).
if choice 2 is selected, only "e" would be displayed (not e f g h)
etc...

is this possible??

please email me with a solution!

thanks!

--
jacke613
------------------------------------------------------------------------
jacke613's Profile: http://www.excelforum.com/member.php...o&userid=18581
View this thread: http://www.excelforum.com/showthread...hreadid=383157

--

Dave Peterson