two way index match with approximate date match

[Kmitchell]

Having difficulty with setting up this formula to work properly. Essentially I need to match on row (Model) and approximate date.

In this example, Model A's closest date to 3/31/2023 is 3/30/2023 and the return value should be 87,800. I tried the below formula but its not working. Any suggestions are greatly appreciated.

NDEX($B$2:$K$15,MATCH($A22,IF($B$1:$K$1=B$21,$A$2:$A$15,1)))

 

[Kmitchell]

Your expected results still do not match the data.
Maybe

=LET(f,CHOOSECOLS(FILTER(B2:K15,A2:A15<=A18),MATCH(B17,B1:K1,0)),FILTER(f,f<>"","no data"))

oh rather I see it's giving me the 4 values less than and equal to 3/31/2023. How do I adjust to return only the latest date on or before 3/31/2023, in the case of model C the expected result is 87,800

 

[Kmitchell]

=LET(f,CHOOSECOLS(FILTER($B$2:$K$15,$A$2:$A$15<=$A18),MATCH(B$17,$B$1:$K$1,0)),TAKE(FILTER(f,f<>"","no data"),-1))

Genius! Thank you SO much

 

[Fluff]

Glad we could help & thanks for the feedback.