Show info in Column C, if A & B match criteria

**PowerSchoolDude** · 08-20-2009, 06:50 PM

Hi!

What I'm having a hard time is trying to get information from column C to pull into a cell, for a specific student (column A), but only when the entry happens between two set of dates (column B).

Column A = Student Name
Column B = Entry Date
Column C = Entry

So in a different worksheet, the names of the students will already be on the report and each column following will have a date range of a week. So for column B I want the entry that only happened between "09/07/09-"09/13/09". No student will have more than one entry a week so I just want it to locate the entry and fill in automatically. This will repeat for each week after as well.

I've attached the workbook sample because I'm very bad at explaining things.

Thanks!

- Santana

**pickslides** · 08-20-2009, 07:30 PM

I would try something like this in a new column as a identifier for date.

Please Login or Register  to view this content.

Then you could sort this row, everything with a '1' sit between the required date.

**DonkeyOte** · 08-21-2009, 02:38 AM

Perhaps based purely on your example:

Please Login or Register  to view this content.

**PowerSchoolDude** · 08-21-2009, 03:02 PM

Thank you guys for the help! You guys got it to work!

I altered it a little bit to search between two dates and it works!

=LOOKUP(2,1/(('Paste Here'!$A$2:$A$9=A2)*('Paste Here'!$B$2:$B$9<=DATE(2009,9,13)*('Paste Here'!$B$2:$B$9>=DATE(2009,9,7)))),'Paste Here'!$C$2:$C$9)

Thank you thank you thank you! You guys rock!