In Excel, at B3, I use data validation of List and entered:
In B2 I put the name of the range I defined. This works well. I enter the name of the range in B2, and B3 is updated with the list of the corresponding range.
Now I transfer my Excel worksheet to Google Sheets. And it no longer works. I just get the error:
And there aren't any items in the dropdown.
I read some old answers about this problem; one suggested to use ARRAYFORMULA like so:
but I still get an error:
Please enter a valid range
and it didn't allow me to save the validation.
What can I do?