I need to create an excel formula that is tiered,in that when using drop down
menus, the selection you make will determine the "consider list" for the
next cell.
Example: A1=1, then selection for A2 is A,B,C,D, etc.
If A1=2, then selection is !@#$% or something like that.
If anyone knows what this formula is called or can point me in the right
direction it would be apprieciated.
Toppers - 31 Jul 2007 20:34 GMT
See:
http://www.contextures.com/xlDataVal02.html
> I need to create an excel formula that is tiered,in that when using drop down
> menus, the selection you make will determine the "consider list" for the
[quoted text clipped - 5 lines]
> If anyone knows what this formula is called or can point me in the right
> direction it would be apprieciated.