Google Sheets Array Formula Match on Multiple Conditions, 1 being date that is less than or equal to

Question

I am hoping someone can help me out.

I have 2 different datasets and I am hoping to replicate the maxifs function using an arrayformula so that I only need 1 formula and do not need to drag down.

What I would like to do is return a value that matches for a name, and the date is less than or equal to a date in the column.

I have added a picture below

Demo

The maxifs formula I am trying to replicate in this case is: =maxifs(I:I, A:A, G:G, H:H, "<=" & B:B)

Sample Sheet: https://docs.google.com/spreadsheets/d/1mMMT1JbBMTAM0togUFQtctpY5FKzgVaP2_YKnALoHAE/edit?usp=sharing

Thank you in advance.