find reference cell based off 2 criteria

Hello,

i need to find the retail, example document attached.

was thinking index match formula but the row that is selected depends on 2 criteria, 1 is an exact match the other one just the date less than defined.
otherwise i would just concatenate the two rows to get a unique value.

thanks
Ross

Show the expected result also since your description is not clear

A simple Pivot Table will do it for you in 4 clicks.

Whether Pivot solution is ok for you?

Or

Looking for formula solution alone?

Please confirm

=IFERROR(INDEX($C$2:$C$16,MATCH(MAX(INDEX(($A$2:$A$16=$F11)*($B$2:$B$16<=G$10)*($B$2:$B$16),0)),$B$2:$B$16,0)),"")
Try this in G11 and copy across

Refer the attached file for Pivot Table solution