IF / VLOOKUP

Pippy79

Board Regular
Joined
Nov 18, 2021
Messages
66
Office Version
  1. 365
Platform
  1. Windows
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.


ABCD
1MP day - 2Collection Day - 2
2MP DayCollection DayCollection TimeDispatch Notification
3MonSat13:00Thurs
4TueSun13:00Fri
5WedSun13:00Fri
6ThuWed11:00Mon
7FriWed11:00Mon
8SatWed11:00Mon
9SunSat13:00Thurs

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 NotificationCollection DayCollection Time

Thanks
Phyl
 

Pippy79

Board Regular
Joined
Nov 18, 2021
Messages
66
Office Version
  1. 365
Platform
  1. Windows
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 DayDispatch NotificationCollection DayCollection Time
Wed, 02-Feb-22FriSun13:00

Could it show:
MP DayDispatch NotificationCollection DayCollection Time
Wed, 02-Feb-22Fri, 28-Jan-22Sun, 30-Jan-2213:00

The MP dates will change throughout the year.

Thanks
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
77,771
Office Version
  1. 365
Platform
  1. Windows
As this is a totally different question, it needs a new thread. Thanks
 

Forum statistics

Threads
1,176,276
Messages
5,902,292
Members
434,959
Latest member
etb1025

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top