Iferror(Index&Match&Match) formula

[Jyggalag]

Hi all!

I currently have a large worksheet that is similar to this:

With the master data looking like this:

I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE].

So for example, I would like for cell E5 on the frontpage to return the value "June 13", seen as it is given as the date in the master sheet (please note that master sheet should be 2020, not 2021, I apologize for this error).

Can somebody help me write down this formula? Please let me know if you any questions!

Any assistance would be greatly appreciated! I tried doing it myself, but I keep getting the error value from the formula unfortuantely.

Kind regards,
Jyggalag