Assume dates are entered in B1:F1 and individuals in A2:A10 so that the
work remaining is in B2:F10. If X and Y are the values you want to
find:

= INDEX(MATCH(Y,A2:A10,0),MATCH(X,B1:F1,0))

MATCH finds the position of each value in each ray (0 means match
exactly, see help for other options)

INDEX finds the intersection of the two positions.

Hope that helps

- John
www.JohnMichl.com