#1
|
|||
|
|||
Multiple match values for INDEX(MATCH) formula
Hi I am looking for a formula that will link two sheets based on multiple match conditions.
I have a Training Matrix filled with columns such as: Name, Job Title, Location, Training title e.g CDM Awareness, GWO Bundle...) I have another sheet filled with requirments per job role (Location, Job Title, Training title - ticked if required) I would like a sum on the matrix that will look up the requirements sheet and if the Job Title, location match and the Training title is ticked it will return "Required" in the cell on the matrix. |
#2
|
||||
|
||||
Suggest you upload a sample of your data with a mocked up solution. No pictures as we cannot manipulate data in a picture.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Values are missing from INDEX & MATCH Equation | suniltko | Excel | 1 | 06-05-2019 12:05 AM |
Index Match Formula | ZetteS | Excel | 3 | 09-21-2018 12:57 AM |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
How to make MATCH/INDEX formula return multiple successive responses. | danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |