+ Reply to Thread
Results 1 to 14 of 14

Multiple Criteria Lookup with Index and Match

Hybrid View

paradise2sr Multiple Criteria Lookup with... 06-21-2021, 12:42 AM
AliGW Re: Match Index 06-21-2021, 12:44 AM
paradise2sr Re: Multiple Criteria Lookup... 06-21-2021, 02:44 AM
kvsrinivasamurthy Re: Multiple Criteria Lookup... 06-21-2021, 03:09 AM
AliGW Re: Multiple Criteria Lookup... 06-21-2021, 05:33 AM
paradise2sr Re: Multiple Criteria Lookup... 06-21-2021, 05:10 AM
Bo_Ry Re: Multiple Criteria Lookup... 06-21-2021, 06:12 AM
wk9128 Re: Multiple Criteria Lookup... 06-21-2021, 07:48 AM
paradise2sr Re: Multiple Criteria Lookup... 06-21-2021, 08:46 AM
wk9128 Re: Multiple Criteria Lookup... 06-21-2021, 08:52 AM
paradise2sr Re: Multiple Criteria Lookup... 06-21-2021, 08:59 AM
wk9128 Re: Multiple Criteria Lookup... 06-21-2021, 09:12 AM
paradise2sr Re: Multiple Criteria Lookup... 06-22-2021, 12:49 AM
kvsrinivasamurthy Re: Multiple Criteria Lookup... 06-22-2021, 01:11 AM
  1. #1
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,842

    Re: Multiple Criteria Lookup with Index and Match

    1. Pls change Cell W3 From "Pull 1 i.e F Column Data" To "Pull 2 i.e F Column Data"

    2. Cell L7 Array Formula , Drag down and across (From L7 To AF8)

    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Re: Multiple Criteria Lookup with Index and Match

    L3 row is not required to get match.I think the formula is ok but array formula slows down as I have to copied down to 3500 rows.
    Last edited by AliGW; 06-21-2021 at 08:50 AM. Reason: PLEASE don't quote unnecessarily!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. Replies: 3
    Last Post: 05-02-2013, 01:31 AM

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