How to get the maximum purchase price from another sheet by date?

Question

Google Sheets

Tell me how to get the last purchase price by date from the "Goods Receipt" sheet and substitute it in 1 sheet?
Here is the table
https://docs.google.com/spreadsheets/d/1X8voLVjCJO...
That is, for example, we search in the "CODE" field and find the closest date to today (for example, 29.04.21) and display the cost of 74 on 1 sheet

Answer 1

Maybe,

=VLOOKUP(F4;FILTER('Поступление_товара'!D:I;'Поступление_товара'!C1:C=B9);4;-1)

Pay attention to 4-ku. It points to the column number for the found row.