Hi Gurus,

I have a sheet which has a Type of Product, Shipping Day and Order Date. Along with this there is also a matrix of dates.

Example for line 1: Formula should look for ship date in "WednesdayA" column and return the next possible shipping date (should be greater than order date).

Can you please help me with a formula using XLookup or Index/Match which can return this result. I have also added a expected outcome column in below table.

I have a sheet which has a Type of Product, Shipping Day and Order Date. Along with this there is also a matrix of dates.

Example for line 1: Formula should look for ship date in "WednesdayA" column and return the next possible shipping date (should be greater than order date).

Can you please help me with a formula using XLookup or Index/Match which can return this result. I have also added a expected outcome column in below table.

__Table of Order Data__Group | Ship Week Day | Order Num | Order date | Ship Date | Output expected | |

A | Wednesday | 18799288 | 4/21/2022 | 5/4/2022 | ||

A | Wednesday | 18806078 | 4/21/2022 | 5/4/2022 | ||

B | Tuesday | 18812201 | 4/25/2022 | 5/10/2022 | ||

B | Wednesday | 18826555 | 4/28/2022 | 5/11/2022 | ||

B | Thursday | 18831134 | 5/2/2022 | 5/12/2022 |

__Matrix of Shipping Dates:__MONDAYA | MONDAYB | TUESDAYA | TUESDAYB | WEDNESDAYA | WEDNESDAYB | THURSDAYA | THURSDAYB | FRIDAYA |

4/4/2022 | 4/11/2022 | 4/5/2022 | 4/12/2022 | 4/6/2022 | 4/13/2022 | 4/7/2022 | 4/14/2022 | 4/8/2022 |

4/18/2022 | 4/25/2022 | 4/19/2022 | 4/25/2022 | 4/20/2022 | 4/27/2022 | 4/21/2022 | 4/28/2022 | 4/22/2022 |

5/2/2022 | 5/9/2022 | 5/3/2022 | 5/10/2022 | 5/4/2022 | 5/11/2022 | 5/5/2022 | 5/12/2022 | 5/6/2022 |

5/16/2022 | 5/23/2022 | 5/17/2022 | 5/24/2022 | 5/18/2022 | 5/25/2022 | 5/19/2022 | 5/26/2022 | 5/20/2022 |

5/30/2022 | 6/6/2022 | 5/31/2022 | 6/7/2022 | 6/1/2022 | 6/8/2022 | 6/2/2022 | 6/9/2022 | 6/3/2022 |