Issues in writing multiple if conditions inside vlookup [Closed]

Report
-
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
-
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.......

1 reply

Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi s.swamchem,

To determine the earliest date in a set a dates, try using the MIN function.

Best regards,
Trowa