If I have two cells and a named range "Mexico":
A1 contains the string: "Mexico"
A2 is the cell that has required data validation (drop down list).
A2's validation reference to be dynamic, in the sense that I can it reference it to
A1; converting the string "Mexico" to a named range Mexico.
I tried inputting
=INDIRECT(A1) into the cell's validation window.