Hello,

I've been experimenting and trying to google an answer for this, but I haven't had much luck.

I'm trying to find a formula (if it's even possible) that will look up and return values based on specific criteria and date range.

I have the following: E3 is my "Associate field", E5 & E6 are my start and end dates.

I have a second sheet (Errors) with columns "Associate", "Date", "Reference", "Comments".

What I would like is when someone enters a person's name in the first sheet with a start and end date, a list of valuse will be returned on the same sheet giving the Reference and Comments from my Errors sheet. So something like this:

E3 = Test, Test
E5 = 11/1/2014
E6 = 11/25/2014

then below would display all reference and comments pertaining to that name and date range.

Is this possible?