Results 1 to 5 of 5

INDEX/MATCH multiple lookup values

Threaded View

mythbit INDEX/MATCH multiple lookup... 04-06-2015, 05:47 PM
AlKey Re: INDEX/MATCH multiple... 04-06-2015, 06:28 PM
mythbit Re: INDEX/MATCH multiple... 04-07-2015, 08:15 AM
AlKey Re: INDEX/MATCH multiple... 04-07-2015, 08:17 AM
AlKey Re: INDEX/MATCH multiple... 04-07-2015, 08:55 AM
  1. 04-07-2015, 08:17 AM #4
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: INDEX/MATCH multiple lookup values

    Yes, use the same formula and replace TRUE with FALSE.

    =IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($B$3:$E$4)/(($B$3:$B$4=G3)*($E$3:$E$4=FALSE)),ROWS(I$3:I3))),"")
    Last edited by AlKey; 04-07-2015 at 08:54 AM. Reason: Updated formula
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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 for 3 lookup values
    By krazyhype19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2014, 06:58 AM
  2. [SOLVED] Lookup match index multiple values return other columns
    By martypocock in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 11-07-2012, 10:57 PM
  3. Multiple row lookup for INDEX / MATCH?
    By kakarotmf in forum Excel General
    Replies: 5
    Last Post: 07-18-2011, 10:02 PM
  4. Lookup 2 possible values within INDEX/MATCH function.
    By Pete123abc in forum Excel General
    Replies: 2
    Last Post: 06-07-2011, 10:51 AM
  5. Multiple Lookup/Index/Match Help!!
    By JMDU in forum Excel General
    Replies: 1
    Last Post: 03-24-2011, 02:57 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1