can I do data validation based on contents of cell?

[Danny]

I want to do some kind of look up of a named range that will be equal to the
name of the name the user selects.

For example:
if somebody chooses red from the choices of red,blue, or green in the cell
(I used data validation). How can I make it so when the user clicks on the
next column, he or she will see the red dresses. I have setup the named
ranges so 'red' is the named range of all red dresses.

Can I do this with validation?
I tried to enter in
=c3, but that does not work.

What else can I try?
Thanks

 

[Bob Phillips]

Danny,

It can be done with Validation, but it's quite straightforward with VBA as
well. There is an example at

http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic, Dependent Dropdowns

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
try
=INDIRECT(C3)

 

[Danny]

Thank you both for your suggestions.
The indirect function works great.
Also, how would I do it using vlookup or hlookup
I need to return a list of items, not just one item.

Thanks for your help. I am beginning to like excel and the macros and
programming behind the scenes. I am coming over from VBA in access and it
is similar. So I am learning fast.
But still need some help, please see more questions. They are simple.

Danny