Hi All,
I have a question, I'm sure its a simple fix but I cant seem to work it out!
I have a look up table below which is my key for days and times.
the start days are pulled from the below date.
Using the table above "MP Day" I need to display if the using the key in the below table.
If MP day is Wed show dispatch notification as "Friday", Collection Day as "Sunday," Collection time as "13:00".
Thanks
Phyl
I have a question, I'm sure its a simple fix but I cant seem to work it out!
I have a look up table below which is my key for days and times.
A | B | C | D | |
1 | MP day - 2 | Collection Day - 2 | ||
2 | MP Day | Collection Day | Collection Time | Dispatch Notification |
3 | Mon | Sat | 13:00 | Thurs |
4 | Tue | Sun | 13:00 | Fri |
5 | Wed | Sun | 13:00 | Fri |
6 | Thu | Wed | 11:00 | Mon |
7 | Fri | Wed | 11:00 | Mon |
8 | Sat | Wed | 11:00 | Mon |
9 | Sun | Sat | 13:00 | Thurs |
the start days are pulled from the below date.
MP Day |
Wed, 02-Feb-22 |
Tue, 04-Jan-22 |
Fri, 07-Jan-22 |
Fri, 07-Jan-22 |
Tue, 11-Jan-22 |
Tue, 11-Jan-22 |
Using the table above "MP Day" I need to display if the using the key in the below table.
If MP day is Wed show dispatch notification as "Friday", Collection Day as "Sunday," Collection time as "13:00".
Dispatch Notification | Collection Day | Collection Time |
Thanks
Phyl