I have a schedule like this and somehow determined the position of Alice in B7.

Given the index B7, how can I find the matching date? Here it would the first cell above Alice that starts with October.

CodePudding user response：

SUGGESTION

It looks it would be quite tricky to use just solely the pre-defined functions to achieve this, given that the total number of names per dates are random (some dates has only 2 names and other has 3 based on your sample sheet).

You can try using a custom formula for this method, just copy and paste the sample functions below as a

Method 2:

Method 3: Using FINDDATE on a different sheet