Nested Vlookups / Index Match with multiple criteria

[FM1]

I have a Programme Roadmap table with the following:


Column B (row 4) - Business Unit
Column C (row 4) - Business Area
Column D (row 4) - Technology
Columns E to AZ (row 5) are week ending dates

The cell values are as follows:

1. GL (Go-live)
2. PLT-C (Pilot Complete)
3. REQ-C (Requirements Complete)

So if Business Unit "Hello" and Business Area "Aloha" is ear-marked for Go-Live for Technology "MS Excel" on 30th August 2019, I'd enter the value of 'GL' in the corresponding cell.

I am putting together an MI table as described below which is where I need the formula:

Column B - Technology
Column C to AX - Week Ending Date

I need a formula which returns the Business Unit and Business Area based on the Technology and Go-Live Week Ending date in the above table. Using the example above, the formula should return 'Hello Aloha' for column with '30th August' and Row with 'MS Excel'.

 

[FM1]

Bump - any help is greatly appreciated.