Combine search criteria to return a text value from a list

Test.PNG

Hi there,

I am trying to create a weekly schedule so I can see what projects my employees are booked on.

The criteria for the formula is to look for the employee name, if the cell under the week is not blank, return the project code.

Thanks for your help

Assuming, given forum in which this is posted, you're running O365 then you might find TEXTJOIN works for you, e.g:

Formula:

Please Login or Register  to view this content.

you should find you can apply the above to your results matrix E10:I11

Originally Posted by XLent

Assuming, given forum in which this is posted, you're running O365 then you might find TEXTJOIN works for you, e.g:

Formula:

Please Login or Register  to view this content.

you should find you can apply the above to your results matrix E10:I11

Thanks is great thank you!