Look up list values between two values; list row contents

[ACurtis802]

Hi everyone,

Here is what I am trying to achieve:

Sheet2 contains various data, including one column of dates.

What I would like to do is populate Sheet1 with functions that search Sheet2 for date values between two separate date values on Sheet1 (cells F1 and G1). When a match is found on Sheet2, row contents from Sheet2 should populate on Sheet1.

In addition, I would like the functions only to match listings in which the value in column E on Sheet2 is greater than zero.

I have attached a sample workbook that illustrates the structure of the worksheets and the desired results. Looking forward to finding a good solution.

Thanks and best regards,
ACurtis802