Index Match with multiple criteria and date criteria

Hello and thank you in advance for taking the time to look at my question ...

I have uploaded a sample file for what I am looking for.

In table 1, we have a column for a buyer name and another column for the date. Then we have a column for each item for sale.

In the portion where there is a column for each item, I need to report (from Lookup Table tab) the price we are selling the item at to that Buyer for that date.

Prices change, so there is an effective date column in the Lookup Table tab and the match must be the buying date must be greater than or equal to the date in the lookup table.

I'm assuming the lookup table will need to be sorted by descending date?

Please let me know how to solve this.

Thank you in advance again, very much for your help excel gurus!.

Cheers!