Multiple Look Up? Help!

Hi there,

I was wondering if someone could help me with the attached document.
On the first tab called "Missed Deliveries" I have a list of stores which have had missed deliveries and the day of the missed delivery.
The schedule tab has the schedule of all the deliveries for each store and I'm wondering if there is a way to return the next scheduled delivery in the yellow highlighted box.
e.g. If a store misses a delivery on Tuesday and their next delivery is on Friday I would like "Friday" returned in yellow cell.

I trust that makes sense, please let me know if you have any questions.

Thanks so much.

Sam

Thank you, brilliant answer