importing range from another book using data validation in google sheets

user_6091910 0
Viewed 67

I want a drop-down list here :

enter image description here

But the range is in another book called : sheet with range

enter image description here

I've tried to use data validation with "IMPORTRANGE" without success , making the following:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1A8v4TEgibkesX729YcjEDn8RkcogutT_8pgIkggaBfI/edit#gid=0", "Hoja 1!A1:A5)

I get the following :

https://i.stack.imgur.com/4qfJw.png

dropdown google-sheets filter import arrays
1 Answers

this is not possible. you need to import your list in some column first (you can hide it in 3 ways) and only then you can create your dropdown

user_56326290
Related