Data Validation using a SPILL range

[Nicole Jones]

I have created a spill range using the UNIQUE function (sits in G2), I have then used =G2# in the Data Validation to create a dropdown list. This is working for the first cell of the validation range, however not in any below it. The dropdown for all other is blank, the Source for all other cells is exactly the same.

Does anyone have any ideas what might be happening?

 

[Eric W]

Try using

=$G$2#

 

[Nicole Jones]

I have created a spill range using the UNIQUE function (sits in G2), I have then used =G2# in the Data Validation to create a dropdown list. This is working for the first cell of the validation range, however not in any below it. The dropdown for all other is blank, the Source for all other cells is exactly the same.

Does anyone have any ideas what might be happening?

User error, did not use $G$2#

 

[Nicole Jones]

Try using

=$G$2#

Thank you Eric, I just stumbled across that.