# Scheduling formulas

##### Board Regular
Hi All,

I am doing a scheduling formula for work. The workbook has a spreadsheet for a two week period. The main one is the two week schedule itself with about 100 workers in my department. The second sheet is a sign in sheet. What I need is a formula that will make the sign in sheet have set start times for, let's say SUNDAY, and it will reference the schedule and insert peoples names that are working on sunday starting at a certain time and if no one is working at that time then it will be left blank.

Example:

Schedule
Sunday

Name Start:
John 06:00
Jack X
donna 06:30

==>

Name: Time
John 06:00
Xblank 06:15
Donna 06:30

Is my explanation clear?

Any help would be appreciated as I have been working on this for months now with no working solution.

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
sheet 1 will be this

Name Start:
John 6:00
jack
donna 6:30

sheet2 will be

Name: Time start time formula for column c
John 6:00 6:00 =VLOOKUP(A3,Sheet1!\$A\$2:\$B\$5,2,FALSE)
6:15 #N/A =VLOOKUP(A4,Sheet1!\$A\$2:\$B\$5,2,FALSE)
Donna 6:30 6:30 =VLOOKUP(A5,Sheet1!\$A\$2:\$B\$5,2,FALSE)

Thanks,

I tried the formula and it kept on giving me #ref errors

Replies
0
Views
183
Replies
2
Views
218
Replies
5
Views
316
Replies
1
Views
522
Replies
5
Views
300

1,212,143
Messages
6,106,213
Members
448,006
Latest member
oreo2996

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back