index match - 2 criteria (Date & String) one needs to be less than the other exact

goodafternoon

first post...

I have 2 tables, "picked sales orders" and "produced goods". 1 lot can contain multiple pallets. I need to find the produced pallet in "picked sales orders" from the table "produced goods".
So I have to find closet date less than the picked date in the table produced goods with exact match to the lot.

In my formula it gets the date correct but not the exact lot.

Dont quite know how to formulate it correctly in Excel... Any help would be much appreciated!

Picture:
Knipsel.JPG
Example (wasnt able to upload attachment)
https://we.tl/g3BfF6YX1K

thank you!