#1
|
|||
|
|||
Match multiple lookup values?
Book1.xlsx
I would like to get the last elective exam date per each student (cell in orange). I got stuck in the INDEX LARGE IF array formula and would like some help. Please see the attachment. Thanks! |
#2
|
|||
|
|||
Is the attached what you want?
|
#3
|
|||
|
|||
@tinfanide
Feeling a bit disillusioned that an expert like you apparently don't bother to respond. |
#4
|
|||
|
|||
Indeed. Busy work has kept me working out your formula from time to time. Up till now I'm still stuck at how MMULT works. That sounds overwhelming to me.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to match values across multiple sheets | coxyada | Excel | 2 | 12-13-2016 03:44 PM |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
using two lookup values to get a sum figur | Ian A King | Excel | 3 | 05-18-2015 02:56 PM |
Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |
How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |