G
Guest
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.
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.