How to quickly find the person on duty using the index function in Excel

1. For the data in the table, use the function to find the person on duty.

2. Enter the function =INDEX(C29:G37,MATCH(J29,B29:B37,0),MATCH(I29,C28:G28,0)) in the cell.

3. Function =INDEX(C29:G37,MATCH(J29,B29:B37,0),MATCH(I29,C28:G28,0)), parameter C29 :G37——Search area.

4. Function =INDEX(C29:G37,MATCH(J29,B29:B37,0),MATCH(I29,C28:G28,0)). Parameter MATCH(J29,B29:B37,0)——Search time period.

5. Function =INDEX(C29:G37,MATCH(J29,B29:B37,0),MATCH(I29,C28:G28,0)). Parameter MATCH(I29,C28:G28,0)——Search area.

The above is the detailed content of How to quickly find the person on duty using the index function in Excel. For more information, please follow other related articles on the PHP Chinese website!