Hi there,
I'm quite new to the forum and glad to be here.
I have been going nuts trying to find the right/best formula to solve what seems to be a simple aim...
as per attached sample file within cell B16 I'm trying to return a value of 1 if the team member on that row (Bob) was present in the team on the column date above (in B15), using a nested formula to find the name row in the table A5:A12 and verify if the date is within the range that they were in the team.
I've tried all sorts of array formulas using IFS, Index Match and SUMPRODUCT but I can't get it to work and am seeking help before I go crazy.
Many thanks in advance for any pointers in the right direction....
Mark
Bookmarks