IF / VLOOKUP

[Pippy79]

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.

	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

 

[Pippy79]

Hi Again,

Just working through this, is there a way to display an actual date instead of the day?

Current formula;

INDEX(FILTER($B$3:$D$9,$A$3:$A$9=TEXT(G2,"ddd")),{3,1,2})

Currently displays:

MP Day	Dispatch Notification	Collection Day	Collection Time
Wed, 02-Feb-22	Fri	Sun	13:00

Could it show:

MP Day	Dispatch Notification	Collection Day	Collection Time
Wed, 02-Feb-22	Fri, 28-Jan-22	Sun, 30-Jan-22	13:00

The MP dates will change throughout the year.

Thanks

 

[Fluff]

As this is a totally different question, it needs a new thread. Thanks