You need a "worksheet change event". Dave McRitchie talks about them he
http://www.mvps.org/dmcritchie/excel/event.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"JonathanW" wrote in message
...
I want to achieve an outcome of if someone changes either cell A3 or B3,
that
share the same validation list, then cell A1 updates depending on which
was
most recently updated.
A1: Apple
Lookup Price Check Product
A3:Apple B3:Apple