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.