# How do I lookup employee's next scheduled date and time?

#### mattshu67

##### New Member
I have one sheet that contains a list of employees and training modules they need to complete. On another sheet, I have a list of the employees and their schedule for the week.

I'd like to make a column on the sheet with training modules that looks up that employee's schedule and gets their next scheduled date and the shift they're working (if they're not working the current day)

Forgive me for not posting an image or an interactable spreadsheet as I thought this was probably simple enough to yield a simple answer that my brain can't wrap around

Schedule sheet:
 Employee Sat, 06/26 Sun, 06/27 Mon, 06/28 Tue, 06/29 Wed, 06/30 Thu, 07/01 Fri, 07/02 VAN-MICHAEL JUD 11:00am-8:00pm 11:00am-8:00pm OFF OFF 11:00am-8:00pm 11:00am-8:00pm OFF RICHARD BRI OFF OFF 4:00am-1:00pm OFF OFF 4:00am-1:00pm 4:00am-1:00pm GREGORY JAC 7:00am-4:00pm OFF OFF 7:00am-4:00pm OFF 7:00am-4:00pm OFF EUGENE SEL OFF 10:00pm-7:00am 11:00pm-7:00am 10:00pm-7:00am 10:00pm-7:00am 10:00pm-7:00am OFF BENJAMIN LEV 1:00pm-10:00pm 1:00pm-10:00pm OFF OFF OFF 1:00pm-10:00pm 1:00pm-10:00pm

Training Module sheet:
 Employee Item Name Next Scheduled Date BENJAMIN LEV Controlled Substances Refresher EUGENE SEL AP-09 Intervention GREGORY JAC Manager Responsibilities and Policy Refresh RICHARD BRI AP-09 Intervention VAN-MICHAEL JUD AP-09 Authorized Employees

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### Momentman

##### Well-known Member
So what would the answers be for those Employees in the table? so we know what the formula should return

#### mattshu67

##### New Member
So what would the answers be for those Employees in the table? so we know what the formula should return
It would be great if I could get the day and time they work in the C column under 'Next Scheduled Date' if that's what you're asking

#### Momentman

##### Well-known Member
It would be great if I could get the day and time they work in the C column under 'Next Scheduled Date' if that's what you're asking
I get that part. I was only trying to be sure what criteria will feature or not. if I take Benjamin Lev for example, since today is 30th June and he is OFF, the answer should be 1st July and 1-10pm, is that correct?

#### mikerickson

##### MrExcel MVP

Cross-posted

(How do I post a simple link that doesn't expand into a (logoed) advertizement for the other web site. <noparse> Link and <Url> both auto convert to a [media] tag. </noparse>)

#### mattshu67

##### New Member
I get that part. I was only trying to be sure what criteria will feature or not. if I take Benjamin Lev for example, since today is 30th June and he is OFF, the answer should be 1st July and 1-10pm, is that correct?
Yes please! Someone suggested using a MINIFS() function but I'm having trouble figuring out which references go where

#### mattshu67

##### New Member

Also didn't realize cross-posting was against the rules--sorry, just a beginner desperate to understand

#### mikerickson

##### MrExcel MVP
Cross posting isn't against the rules, but when one does, including a link to the other post is courteous. Some sites require that degree of courtesy, others just recommend it.

#### Fluff

##### MrExcel MVP, Moderator
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Cross posted at: How to find next scheduled date of employee
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Replies
1
Views
159
Replies
7
Views
107
Replies
3
Views
201
Replies
15
Views
221
Replies
1
Views
145

1,147,815
Messages
5,743,366
Members
423,790
Latest member
kevinlee_5

### 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