+ Reply to Thread
Results 1 to 4 of 4

I have INDEX MATCH formula that does not work for one array but does for another

  1. #1
    Registered User
    Join Date
    11-18-2004
    Location
    San Jose, CA
    MS-Off Ver
    Windows 2010 with Office Suite 2016
    Posts
    10

    I have INDEX MATCH formula that does not work for one array but does for another

    I’m stumped.

    Bottom Line Up Front: I used a formula for one array that worked. I copied formula and changed relevant details to the new array but it does not work.

    INDEX MATCH formula that works is from F32-F280.
    =INDEX($A$2:$AN$29,MATCH(C32,$A$2:$A$29,0),MATCH(D32,$A$2:$AN$2,0))

    INDEX MATCH formula that does not work:
    =INDEX($AQ$2:$BO$30,MATCH(C32,$AQ$2:$BO$2,0),MATCH(L32,$AQ$2:$AQ$30,0))


    The working formula indexes:
    ~Pay Grades from row A2-A29 and
    ~Years working from B2-AN2
    ~And produces the Base Pay (BP) of the employee in F32-F280.


    The non-working formula indexes:
    ~Pay Grades from row AQ2-BO2 and
    ~City where housing allowance is calculated from AQ2-AQ30

    It does not work as it keeps producing the wrong amount.

    I have no idea what I did wrong so thank you for your tiime.
    Attached Files Attached Files
    Last edited by davism2; 03-31-2013 at 11:42 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: I have INDEX MATCH formula that does not work for one array but does for another

    Try swapping the two MATCH sections around, so you have:

    =INDEX($AQ$2:$BO$30,MATCH(L32,$AQ$2:$AQ$30,0),MATCH(C32,$AQ$2:$BO$2,0))
    If I've been of help, please hit the star

  3. #3
    Registered User
    Join Date
    11-18-2004
    Location
    San Jose, CA
    MS-Off Ver
    Windows 2010 with Office Suite 2016
    Posts
    10

    Re: I have INDEX MATCH formula that does not work for one array but does for another

    Star has been hit with pleasure. Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: I have INDEX MATCH formula that does not work for one array but does for another

    Happy to help

+ Reply to Thread

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