Index + Match - multiple criteria, multiple returns

masbery

New Member
Joined
Oct 1, 2011
Messages
3
Hello,

I've created a resource scheduling tool for my company that is based on days per weeks, projects that each resource is working on etc. I have a sum up at the bottom to ensure that each resource is not over allocated in each particular week, but as the number of projects is increasing, i would like to add a look at the bottom of the sheet to report back which projects each resource is allocated to.

I've looked at a number of sites and have tried a number of methods, but none have produced the required outcome.

I've uploaded a sample spread sheet here. In cell E60 i am looking to return the initial (Column C) of the project that the resource is allocated to (if they are allocated to anything that is).

For example, Luca Volpe is allocated to DS1 and PP2 in column E, so in his section in cell E72 and E73 I would like the result of DS1 and PP2. I can add a helper colunm in to duplicate the name of the person for each of the 3 rows that are allocated to each person if needs be.

Any help on this one would be gratefully received.

Many thanks, Mark.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,596
Messages
5,832,640
Members
430,150
Latest member
amitk1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top