Index - Match Formula
Formula can be used to pull information from one source into another place.
For example below if you would like to know the day that a member of the team cannot work you would complete the formula as follows
=index (days cannot work, MATCH(persons name, all names, FALSE),1)
Marked in red are details you would enter.
So below, for Jane, the formula would look as follows:
=index ($E$18:$E$43,MATCH(A18,$D$18:$D$43,FALSE),1)
You musnt forget to put the $ sign in
This formula only works if the match (in this case the names) are all different.