lookup Multiple occurances/values between two dates or date range.

Greetings from India.
am creating a review calendar for standards and legal requirements.
the columns r as follows and the same are in sheet1
std no/act no., last review done, deferred date, activity done.

Am creating a summary between two dates, say from 01.01.2016 to 31.01.2016 for the last review done and the summary to show the std no/act no in the reviewed by lookup multiple values/occurances between these dates. is that possible?
have tried and searched, but was in vain.
please can you experts guide?
Regards.

Originally Posted by sourabhg98

Maybe this is what you need-
(Check attached)
Put data in "Data" sheet. Check results in "Result" Sheet.

Greetings,
have attached the sample sheet.
Wow Sourabh,
Great work, am blessed.
truly like Saurav Ganguly.........The master of Eden Gardens.....
Thanks a lot.
You saved a lot of my time.
Regards.