Function: Index

is it possible to index another Sheet?
i’ve been trying to do something like:

So, I’ve noticed that if I’m in Sheet1 I can create a data type and run:
I’ll get the full list automatically

If I’m in a different sheet, and try to reference Sheet1 with a data type:
I get an error.

If I use this formula in a cell by itself:
it works, and I can drag it down as far a I need.

You mean using INDEX in the column formula - Right?
Currently INDEX(Sheet1!A) ( cross sheet column formula ) is not supported.

1 Like

correct. thanks for the update.