+ Reply to Thread
Results 1 to 3 of 3

INDEX MATCH formula bringing back incorrect data

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Red face INDEX MATCH formula bringing back incorrect data

    Hi Everyone,
    I'm new to the forum and have had a search around but can't find the answer to my problem - apologies if I've missed it, my excel knowledge is not that great so it may be that someone has posted an answer to another query and I just don't realise it solves my issue!

    I've attached a small sample of what I'm trying to achieve, I want to pull the amount being produced on a specific product and date through from the "Plan" sheet to the "Bulk" sheet (the formula is in C18 on the attached), the "Plan" sheet will get copied in from another source daily and can't really be altered but I can make any amendments at all to the "Bulk" sheet.

    I've currently used this formula:

    =INDEX(PLAN!$C$2:$AM$34,MATCH(BULK!$A$18,PLAN!$C$6:$C$31,0),MATCH(BULK!C6,PLAN!$C$2:$AM$2,0))

    However, the result been brought back is from row 7 rather then row 11 as I'd expect. When I do this same calculation on my original spreadsheet (not this reduced sample) it brings back the data for the correct row but the incorrect column so I'm obviously doing something wrong but I have no idea what.

    Any suggestions would be gratefully received....

    Many Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: INDEX MATCH formula bringing back incorrect data

    Use the below code in C18. The range was incorrect and read C$6:C$31 earlier.

    =INDEX(PLAN!$C$2:$AM$34,MATCH(BULK!$A$18,PLAN!$C$2:$C$31,0),MATCH(BULK!C6,PLAN!$C$2:$AM$2,0))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    06-27-2012
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: INDEX MATCH formula bringing back incorrect data

    Thank you Ace_XL, that's perfect!

+ 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