Passing Morethan one value and returning multiple values

**kran** · 08-04-2009, 10:42 PM

Hi all,

Am new to this forum. Attached simple xls as info for my requirement ..

Am trying to slect list of values followed by cascading values through Vlookup..is this possible in Excel. Hope I receive a solution for this.

thanks, kran

**JBeaucaire** · 08-05-2009, 02:29 AM

'DEPENDENT DROP BOXES
These are called Dependent Drop Down lists and they use named ranges and INDIRECT() references in the proceeding drop boxes.

Here's a sample sheet I've posted showing how it's done. The sheet "CHOICES" has the dependent drop lists (and shows one of the dangers of using them) and the sheet "LISTS" shows the lists and named ranges in use.

Have a look.

Sample Files
http://www.excelforum.com/attachment...dentlists3.xls 3 levels
http://www.excelforum.com/attachment...dentlists2.xls 2 levels
http://www.excelforum.com/attachment...elfsorting.xls Self-Sorting lists of fruits by color choices

More reading:
http://www.contextures.com/xlDataval02.html
http://www.contextures.com/xlDataVal13.html

'Unique Values from Repetitive data in a drop box
http://www.excelforum.com/attachment...dationlist.xls

**kran** · 08-05-2009, 03:09 AM

thanks for the immediate response and the valuable information. I shall be able to resolve this now. thnx again ...Kran

**JBeaucaire** · 08-05-2009, 03:15 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)