I have been unable to get the Indirect portion of a formula to work.
The following formula works but when I tried to include an Indirect Index all I get is #REF!
![]()
=INDEX('2011'!DJ$9:DJ$24, MATCH($O$3,'2011'!$A$9:$A$24,0), MATCH($M18,'2011'!DU$3,0))
This is how I tried to add the Indirect portion.
Thanks![]()
=INDEX(INDIRECT($L$3&"!"&DJ$9:DJ$24), MATCH($O$3,INDIRECT($L$3&"!"&$A$9&":"&$A$24),0), MATCH($M18,INDIRECT($L$3&"!"&DJ$3),0))
Jim O
Bookmarks