Vlookup on multiple matches

[fhaid]

Dear All

I have a query related to multiple matches through VLookup
In my attached sheet I have 2 list.

List1 has Field1 and Time.
List 2 has Field2

Field2 matches to Field1 to get the output on column E through Vlookup. But due to multiple matches I cant have the desired output.

Desired Output is mentioned on the sheet (download from the link below). This could be a randomly match
Looking forward to crack this multiple match from my friends.

Many Thanks
Haider



Below is the file link to download file

https://drive.google.com/open?id=1caOw3wrmgHh5q65P6EzqiQMKMg_hM2P3

 

[Fluff]

Maybe
=INDEX($B$2:$B$275550,AGGREGATE(15,6,(ROW($B$2:$B$275550)-ROW($B$2)+1)/($A$2:$A$275550=D2),(COUNTIF($D$2:$D2,$D2)-1)*6+1))
this will give every 7th value

 

[Aladin Akyurek]

The desired output does not seem to show any structure. If thi observation is correct, any random output should be acceptable for a given look up value!