I'm using data validation and in cell CG4, what I would like to happen is:
1 - If cell AF4 is "Individuals", then the user cannot do anything in cell CG4.
2 - If Cell AX4 is "US" then populate cell CG4 with "United States".
3 - If cell AX4 has a non-null value that is not "US", then cell CG4 should display a dropdown list where a country can be chosen.
I've tried numerous things, but to show you my base starting point, here's the data validation formula i'm using that doesn't work:
=IF(AF4="Individuals","",IF(AX4="US","United States",Sheet2!$F$2:$F$234))
Sheet 2 contains the list of countries for the third scenario.
Bookmarks