is it possible to index another Sheet?
i’ve been trying to do something like:
index(Sheet1!A)
So, I’ve noticed that if I’m in Sheet1 I can create a data type and run:
Index(A)
I’ll get the full list automatically
If I’m in a different sheet, and try to reference Sheet1 with a data type:
Index(Sheet1!A)
I get an error.
If I use this formula in a cell by itself:
Index(Roster!A2)
it works, and I can drag it down as far a I need.