Manual Selection 1 or the other

L

Lazarus

Is there a facility within Excel for making an external user answer a
question based on a critera he/she provided in a previous cell, and then
respond based on the answer?
 
L

Lazarus

That solves the question part of it:D

Based on the second drop down (result of the indirect validation)

Is there a way to alter existing data based on the answer??

IS

A B
1 Drop1 Drop2
2
3 52 27

I want to add 1 to either A3 or B3 Based on weather the drop2 is responce1
or responce2....
I also would like the 1 to be taken away if the drop2 is then changed or
cleared

Thanks for the help so far Toppers
 
Top