Vlookup on multiple matches

[haiders7]

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 mutiple matches I cant have the desired output.

Desired Output is mentioned on the attached sheet.
Looking forward to crack this multiple match from my friends.

Many Thanks
Haider

[p45cal]

I see:
1. That the field name ends with the hour of the time field
2. That there are 4 results required per hour
3. Perhaps that you want data only from the hours 13,19 & 21

I do not see how you choose which time fields to include - I can't find a pattern, be it in hours/minutes or in the missed out times. What is it that makes you want to pick those specific times from column B?