One more question if anyone can help:
I have a named range, called "vh". The named range itself is a dynamic range, using a formula like this:
=OFFSET('Vahik Haddadian'!$A$2,0,0,COUNTA('Vahik Haddadian'!$A:$A),5)
Now, I want to reference individual cells in this named range using the Index function, like:
And that works fine.
However, in that index function, I want to generate the "vh" part using a reference instead of directly typing it in:
where G2 is the cell whose content is "vh".
The problem is that when the "vh" argument is referenced, it doesn't work properly. Only when "vh" is directly typed does it work properly. Can anyone help me figure out why?