+ Reply to Thread
Results 1 to 11 of 11

**SOLVED** Multiple Lookup search in table and display separate table with matched values

Hybrid View

  1. #1
    Registered User
    Join Date
    01-28-2014
    Location
    Brno
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: Multiple Lookup search in table and display separate table with matched values

    Hi, there is. Not sure if this one is the best one, but works.
    B24=IFERROR(INDEX(B$4:B$19,SUMPRODUCT(SMALL(($D$4:$D$19=$L$3)*($F$4:$F$19=$L$5)*($E$4:$E$19=$L$7)*(ROW($D$4:$D$19)-3),SUMPRODUCT(--(($D$4:$D$19=$L$3)*($F$4:$F$19=$L$5)*($E$4:$E$19=$L$7)=0))+ROW(1:1))),1),"")

    and drag across.
    Attached Files Attached Files

+ 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. Help with table lookup using matched text
    By staticsnake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2014, 01:33 PM
  2. [SOLVED] Search for multiple string values in the first row of a table and format column values.
    By Excel_junky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2013, 12:48 PM
  3. Lookup in one table and display two values in another
    By pafranklin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2012, 05:40 PM
  4. Replies: 3
    Last Post: 05-20-2011, 09:13 AM
  5. Display matched table data in another sheet
    By vanir in forum Excel General
    Replies: 2
    Last Post: 08-30-2009, 09:02 PM
  6. lookup values from multiple formula table
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2009, 11:15 AM
  7. Lookup cell value in separate worksheet and return multiple matched values
    By jwhite68 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2007, 12:17 PM

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