Selecting Value from Drop-down

August 16, 2011 at 02:01:11
Specs: Windows 7
Hi,am Sourabh am having a problem in Excel 2010 as below
I am having a

Sheet with Drop Downs

A B C
Bob Sue =VLOOKUP(A1&B1, Sheet2!A1:B3, 2, 0)


Sheet 2 with lookup_array


A B
SteveBill Data1
BobSue Data2\Data3
BobMary Data3

When i select Bob and Sue in Sheet with Drop down, i get the value Data2\Data3 in Cell C.Cell C is a drop-down but i don't want both the values(Data2\Data3)to be displayed, I should be able to select the value i.e either Data2 or Data3 from the Drop-down in cell C.

Can any one HELP...


See More: Selecting Value from Drop-down

Report •

#1
August 16, 2011 at 04:12:54
First, before you post any more data in this forum, please read the instructions found by clicking on the Blue sentence at the end of this post.

How can Column C be a Drop Down if it has a Formula in it?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 16, 2011 at 04:27:17
Hey, am sorry for not maintaining indentation and not reading that before. You can have drop-down in Cell C as am getting multiple values on certain criteria from datasheet and user will decide what he wants. so i need it, Is there any way i can select single value from what i get in Cell C???

Report •

#3
August 16, 2011 at 05:02:21
If you want to put a Dependent Drop Down in Column C, read the instructions found here:

http://www.contextures.com/xldatava...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
August 17, 2011 at 23:58:51
hey thanks for the link. Can i give alias name for the named range........
I have a field Budget in first drop-down and 01 Planning, strategy in second drop-down. Based on the above criteria i will get some values in cell C drop-down. Since named ranges don't allow special characters or spaces how can i give a name to the above combination as i cannot change the formatting in second drop-down field names.

Report •

#5
August 18, 2011 at 04:29:42
You need to start think creatively when it comes to creating Named Ranges.

If you can't using special characters, then eliminate them.

With 01 Planning, strategy in A1, this will return Planningstrategy

=MID(A1,4,8)&MID(A1,14,8)

Use that as your Named Range and this as the Data Validation List Source:

=INDIRECT(MID(A1,4,8)&MID(A1,14,8))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
August 24, 2011 at 22:42:56
Hi, thanks a lot for your help with those formulas... could you suggest me a sample macro code for the same as my Team lead wants both the solutions and then will decide what suits best... could suggest something..

Report •

Ask Question