troubleshooting Question

Excel - indirect ranges intersection not working

Avatar of mircea_a
mircea_a asked on
Microsoft OfficeMicrosoft Excel
13 Comments1 Solution633 ViewsLast Modified:
Hello,

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?

Notes:
mi_field - contains the name of another range ("January")
mi_f1 - is itself a range
(january mi_f1) - is an intersection which works

Thanks,
M
ASKER CERTIFIED SOLUTION
patrickab

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros