So I'd like, for various reasons (mostly to get equations further down the line to work) to call multiple ranges the same thing. Ok, doable in name manager. Lists is now defined as A1:A10,C1:C10. Typing in lists highlights both, great.
=Index(Lists, 1)
gives me the first cell in A,
=Index(Lists, 8)
gives me the 8th cell, great.
=Index(Lists,11)
I'd expect to give me the 1st cell in C, however it gives me a #REF instead. How can I make it so that Index(Lists, 11) gives me the first number in C?