Closed Thread
Results 1 to 2 of 2

Index Match for multiple columns

  1. #1
    Registered User
    Join Date
    10-23-2018
    Location
    Brisbane
    MS-Off Ver
    365
    Posts
    7

    Index Match for multiple columns

    Repost with attachment

    Hi all,
    I’m using the index and match functions in the formula below to find a row that matches the value from cell PMP!$A3 in column PMPQueryAll!$C:$C and the value from cell PMP!B$1 in PMPQueryAll!$I:$I.

    It then returns the values in that row from columns PMPQueryAll!$F:$F and PMPQueryAll!$H:$H.

    This all works but is extremely slow. Can anyone help with a function or perhaps rearrange the formula to achieve the same result more simply?

    =IFNA(INDEX(PMPQueryAll!$F:$F&" "&TEXT(PMPQueryAll!$H:$H,"dd/mm/yyy"),MATCH(1,INDEX((PMPQueryAll!$C:$C=PMP!$A3)*(PMPQueryAll!$I:$I=PMP!B$1),0),0)),"")

    Thanks for taking a look at my problem 🙂
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,474

    Re: Index Match for multiple columns

    This thread is a duplicate and has been closed. Continue in your first thread, where you can attach the workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index Match across multiple columns
    By cfitz97 in forum Excel General
    Replies: 2
    Last Post: 06-15-2018, 08:53 PM
  2. [SOLVED] Index match to sum multiple match columns
    By rosboy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2018, 04:14 PM
  3. INDEX MATCH MATCH multiple columns with same heading
    By djm198 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2016, 02:34 PM
  4. [SOLVED] Index Match across multiple Columns
    By whiZZfiZZ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2016, 01:05 PM
  5. [SOLVED] index match multiple columns
    By mma3824 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2013, 04:02 PM
  6. [SOLVED] Index / Match across multiple columns
    By Chad B in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 11:52 AM
  7. Index/Match but with multiple columns?
    By notleonardo in forum Excel General
    Replies: 4
    Last Post: 11-17-2011, 07:16 PM

Tags for this Thread

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