Automatically fill in names in a weekschedule

		Microsoft Office Forums > Microsoft Excel > Excel
Automatically fill in names in a weekschedule

11-16-2016, 08:08 AM

gebobs

Windows 7 64bit Automatically fill in names in a weekschedule

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

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, 10 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically Fill Cells in Other Worksheets	MatthewR	Excel	4	07-09-2015 07:13 AM
Word Template: Fill out user E-Mail automatically	MS_Maverick	Office	0	05-09-2014 12:50 AM
How to enter names in Resource Pool/names	pstein	Project	1	03-26-2012 07:37 AM
Automatically fill in bcc	prroots	Outlook	1	06-29-2010 10:56 AM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.