Issues in writing multiple if conditions inside vlookup

Hello,

I have two sheets.

1st sheet has an unique information in the first two columns about bike and its repair date (DD/MM/YYYY) format.

2nd sheet has multiple duplicate entries in the first three columns about bike and its repair date (DD/MM/YYYY) and diagnostic date (DD/MM/YYYY).


Now using vlookup, I have find the diagnostic date, can be equal as the repair date or just before the repair date for the particular bike.


ex:-

for a bike, I have a repair date as 20/02/2017. but with three different diagnostic dates such as (21/02/2017, 27/05/2017 and 28/12/2015).

so Finally I would expect the answer as the follows:-

Bike Repair date Diagnostic date

Name 20/02/2017 28/12/2015

I was managed to do for the entries which has same year for the repair and diagnostic date.

In the prescribed example, It is different.

I would be happy If you help me on this.......