I guess that this should be easy. But I can't seem to figure it out.
I have the name of a list, lets say "List1", inside a cell $A$1. Depending on certain actions in the file, A1 might have another list name in.
What I now need is to take the nth value of this list.
However =INDEX($A$1;1) doesn't work as it thinks that $A$1 is the range. But it should actually look at the name of the list in A1 instead.
As the list name in A1 is based on a VLOOKUP formula I tried to put the VLOOKUP inside the index. But that doesn't seem to work either. Additionally, I wouldn't like to do this VLOOKUP every time again as I don't only need to find the first value in the list but many others as well and want to limit computing time.
Two cents from anybody?
I have the name of a list, lets say "List1", inside a cell $A$1. Depending on certain actions in the file, A1 might have another list name in.
What I now need is to take the nth value of this list.
However =INDEX($A$1;1) doesn't work as it thinks that $A$1 is the range. But it should actually look at the name of the list in A1 instead.
As the list name in A1 is based on a VLOOKUP formula I tried to put the VLOOKUP inside the index. But that doesn't seem to work either. Additionally, I wouldn't like to do this VLOOKUP every time again as I don't only need to find the first value in the list but many others as well and want to limit computing time.
Two cents from anybody?