+ Reply to Thread
Results 1 to 2 of 2

Seach value in matrix with multiple characteristics

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Seach value in matrix with multiple characteristics

    I would like to search a value in a matrix, normally I combine index & match function only this time there are multiple columns with characteristics
    I think this can be done with the formula productsum but I do not know exacly how.
    I also added a small example see attachment
    So if Column A is Appel, column B is one, and Column C is Erik and row is 1 june, what is the corresponding number out of the matrix?

    I hope somebody can help me.
    Thanks!
    Attached Files Attached Files
    Last edited by keis386; 06-25-2015 at 10:03 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,409

    Re: Seach value in matrix with multiple characteristics

    Hi there. this does what you need.
    Formula: copy to clipboard
    =INDEX($D$12:$O$53,MATCH(1,INDEX(($A$12:$A$53=$B$3)*($B$12:$B$53=$A6)*($C$12:$C$53=B$5),0),0),MATCH($C$3,$D$11:$O$11,0))


    See file attached.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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] Extracting data from multiple columns on multiple sheets / tabs etc to a common matrix
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-26-2015, 07:38 AM
  2. Replies: 8
    Last Post: 06-26-2014, 02:37 PM
  3. [SOLVED] seach text within " " multiple times
    By prasjohn in forum Excel General
    Replies: 1
    Last Post: 05-08-2012, 09:59 AM
  4. Sum formula with multiple characteristics
    By rhudgins in forum Excel General
    Replies: 3
    Last Post: 12-20-2010, 05:01 PM
  5. Seach with multiple results
    By LB79 in forum Excel General
    Replies: 0
    Last Post: 04-26-2005, 05:23 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