I've been playing around with the indirect function and intersections a little but got to a point where I can't seem to make it work.
I have the following situation:
=INDEX((INDIRECT(mi_field) mi_f1),B61) - works very well (returns the value of the first cell in the intersection
=INDEX((INDIRECT(mi_field) INDIRECT(Z47)),B61) - Dosen't work :(((( even if Z47 = mi_f1 - isn't this practically the same as the above?
Does anyone know how to get this to work if both ranges of the intersection are indirectly reffered to?
mi_field - contains the name of another range ("January")
mi_f1 - is itself a range
(january mi_f1) - is an intersection which works