Only 32,767 values are permitted in a dropdown list. That is a large number. A list with many values is difficult to utilize.
Instead of data validation with list, use data validation custom. The custom formula for data validation for cell G2 would be
if G1 contains the range name for lookup.