Index/Match with multiple criteria, but one is exact and other is largest without going over

[mst3k4L]

I have a table that looks like the one below with the dates sorted in descending order.

Person	Date	Number
Jose	1/1/2014	98
Rosa	5/14/14	47
Jose	6/1/14	3
Rosa	2/1/15	456
Jose	12/5/15	3
Rosa	5/2/16	-10

I want to enter a name and date and have excel search the table for the exact name and the closest date without going over, and then provide the answer in the "Number" column. For example, entering "Rosa" and "6/2/14" will result in "47", while "Jose" and "6/2/14" will be "3".

I'm assuming it's some combination of Index & Match. Feel free to use something else, but please void VBA if possible. I can resort the table as needed. Thanks in advance!

 

[XLearner]

This actually works!

Good "starting" point
Well, not sure at all it grabs the 1st... Take the same example with Jose and 1/1/16 and before validating change the value of 3 for i.e 100 on the line where Jose has date 12/5/15. What does the formula return?

 

[mst3k4L]

Good "starting" point
Well, not sure at all it grabs the 1st... Take the same example with Jose and 1/1/16 and before validating change the value of 3 for i.e 100 on the line where Jose has date 12/5/15. What does the formula return?

It's working now, but I'm not sure what I did differently. Thanks for the help!