can I do data validation based on contents of cell?

  • Thread starter Thread starter Danny
  • Start date Start date
D

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
 
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
 
Back
Top