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?
Bookmarks