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


"Toppers" wrote:

Possibly using Data Validation ..see
http://www.contextures.com/xlDataVal02.html

but if you give an example of your rquirement, there are might be other
alternatives.

"Lazarus" wrote:

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?