Is it possible? 3 level validation list

  • Thread starter Thread starter Rayzzor
  • Start date Start date
R

Rayzzor

Hello all,

I was wondering if it possible to make a "multi-level validation" list
What I need it to do is the following:

Column A has a drop down list - Standard, nothing fancy
However, when you pick anything from that list, another list say i
Column B, is adjusted so the user can only pick items that ar
specifically 'linked' to that first item. Then I would need the sam
situation to link to Column C, narrowing that list down further. Thi
might only be needed to go down to a 4th level.

If this is possible, please let me know. Now bear in my, I conside
myself a Novice with Excel (2000) and I would need instruction step b
step, if there is any macros or coding involved.

Thanks a million!!!

Donny Wiedeme
 
Thanks for all the help guys.... but I am having one more issue....
need to figure out how to combine these two formulas:

=INDIRECT(SUBSTITUTE(A2," ",""))
=OFFSET(INDIRECT($E2),0,0,COUNTA(INDIRECT(E2&"Col")),1)

What the end result will be is the multi-level validation drop dow
list I am looking for with multiple words.


Thanks again!!!!!!!
 
Back
Top