Issues in writing multiple if conditions inside vlookup

Closed
s.swamchem - Updated on Jun 4, 2017 at 06:44 AM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Jun 6, 2017 at 11:40 AM
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

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jun 6, 2017 at 11:40 AM
Hi s.swamchem,

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

Best regards,
Trowa
0