Forum Discussion
Index Match with IF combination
Hello! I am trying to build a semi-automated master schedule using the Index Match and IF functions but have not been successful in merging the two functions. I have two schedules, one for do...
Hi,
The structure of your schedules is hard to understand and it's not consistent!
So I have created simple schedules to show you how the formula works.
Please find this formula in the Doctors/Nurses table:
=INDEX($A$10:$A$14,INDEX(MATCH(TRUE,INDEX($B$2:$H$6,MATCH($A18,$A$2:$A$6,0),MATCH(B$17,$B$1:$H$1,0))=B$10:B$14,0),))
Please notice how the d1 in Doctors/Nurses table has n2, that's because of his start time matches the n2 start time, same thing for the d2.
I've attached the workbook.
Hope that helps