1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

INDEX and MATCH formula

Discussion in 'Ask an Excel Question' started by muna, Dec 14, 2017.

  1. muna

    muna Member

    Messages:
    62
    Please see the documents attached.

    I need to know how to use an INDEX and MATCH formula.

    Scenario: Using an INDEX and Match formula from one spreadsheet to return data to another workbook.

    Attached Files:

  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,615
    Hi ,

    I think your uploaded file is the wrong one.

    Which cell(s) in which tab(s) in which workbook should have the formula ?

    Narayan
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,426
  4. pecoflyer

    pecoflyer Active Member

    Messages:
    169
    And no links to cross posts...
  5. Marc L

    Marc L Excel Ninja

    Messages:
    4,010


    Wild cross-posting : no help …​
    muna likes this.
  6. muna

    muna Member

    Messages:
    62
    Sincere apologies.

    I've learnt my lesson, it's been two months plus and I am no longer pursuing answers on other forums I have posted on about this issue. Unfortunately, removing the threads from other sites is not an option due to their site rules.

    Please could someone help answer my question in post #1 of this thread?

    Once again, I apologise.
  7. muna

    muna Member

    Messages:
    62
    The formula should be in 015 of the Example 1.xlsx spreadsheet.
  8. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    16,615
    Hi ,

    See if this is OK.

    Narayan

    Attached Files:

    Thomas Kuriakose likes this.
  9. muna

    muna Member

    Messages:
    62
    Thank you for your efforts but just realised the formula I need has to be an INDEX and MATCH combined.

    I have attached a new file.

    Attached Files:

  10. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    1,776
    Please see the attached file with formula revision.

    Regards
    Bosco

    Attached Files:

    Thomas Kuriakose and muna like this.
  11. muna

    muna Member

    Messages:
    62
    Thank you so much!

    I notice you've changed the MID formula in cell E6.

    Was there anything else?

    I ask because I need to replicate the changes in my main excel file.
    Last edited: Feb 26, 2018
  12. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    1,776
    Revision was made in C6, E6 and H6

    C6 and E6, changed to exclude extra space

    H6, to use limited cell range instead of using whole column cell range, it was 1 million cells per column and too much calculation will cause slow down of your computer

    Regards
    Bosco
    Thomas Kuriakose likes this.

Share This Page