Hi all,
I am trying to create a data validation setup that will prevent the user from entering a value in Column A until the corresponding row in Column P has a value. Once this condition is met I would like to allow a selection from a data validation list.
I was able to find a formula to restrict entry on this forum:
=AND(P4<>0,P4<>"")
However I am not certain how to then move to providing for the drop down list. How should I approach this?
Thanks!
Bookmarks