Good Evening
Wondering if any one had a solution - below is a daily time table and the numbers represent personnel
wanted a look up option so that when a month of these are filled it shows the start and finish for each person - tried:
=INDEX(W1D1,MATCH(Names,Room1:Room3,0)) but not working...