Google docs. "Data validation...". Rules: "Value from the list". How to take values ​​from a list of another table?

Question

Google

Good afternoon!
I can not set up data validation in the form of a pop-up list from data from another Google Docs table
There are 2 tables in Google Docs, conditionally Table1 and Table2.
The tables have 1 sheet each, respectively sheet1 and sheet2.
In sheets, ranges, for example:
range1 = [Table1]sheet1!A1:A10
range2 = [Table2]sheet2!A1:A10.
You want the cells in range1 to display a pop-up list of the values ​​contained in range2.
please tell me how it is possible to do this?
Thank you!

Answer 1

Сперва сделать ImportRange из Table2 в Table1, затем использовать его для валидации. Только так.