Microsoft Office Forums - View Single Post - Automatically fill in names in a weekschedule

Thread: Automatically fill in names in a weekschedule

View Single Post

Old

11-16-2016, 08:08 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

I used the following array formula:

Code:

=INDEX(Schedule!$C$2:$J$85,MATCH(1,(Schedule!$J$2:$J$85=Weekschedule!$B13)*(Schedule!$C$2:$C$85=Weekschedule!G$3),0),4)

Remember to use CNTL-SHIFT-ENTER instead of enter. See attached.

Attached Files

Weekschedule.xls (51.5 KB, 8 views)

Reply With Quote