Results 1 to 6 of 6

Problem with INDEX, INDIRECT, MATCH, MATCH

Threaded View

JO505 Problem with INDEX, INDIRECT,... 08-31-2011, 04:56 PM
bentleybob Re: Problem with INDEX,... 08-31-2011, 06:27 PM
JO505 Re: Problem with INDEX,... 08-31-2011, 08:22 PM
teylyn Re: Problem with INDEX,... 08-31-2011, 09:01 PM
JO505 Re: Problem with INDEX,... 09-01-2011, 03:55 PM
JO505 Re: Problem with INDEX,... 09-01-2011, 05:51 PM
  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Problem with INDEX, INDIRECT, MATCH, MATCH

    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.

    =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))
    Thanks

    Jim O
    Last edited by JO505; 09-01-2011 at 05:51 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1