Formula to pull from a value from a category on a date that has 3 merged rows

Hello,

I cant seem to get my formula to work properly, so I thought I would see if there were any other formulas i could use...
In the spreadsheet, there are 2 sheets. The first sheet had Dates vertically with data horozontally, the 2nd sheet is the opposite.
I need to pull the data of a category in sheet 1 from a date to the appropriate cell in sheet 2, the issue is that some of the data that I need to pull is 3 separate rows for one date.

I give an example of what I needed inside the file, if anyone could help out, it would be much appreciated.



Thanks in advance!