Formula to pull text from multiple cells if formula = true

I'm working on a spreadsheet that keeps track of due dates for multiple staff. Basically what I am looking to do is create a sheet that pulls anything due today, so that every day it could be opened and easily seen what is due today. I've attached a sample sheet, but as an example, say I am wanting to see if any of the dates listed are today, and also there is not an 'x' next to that date (which means its completed), it would pull the name of the document due from column A and the name of the person it is due for from Row 1, and output something like "John Smith Process Report". I'd like it to check every box and output this same type thing for everything that is due today.

I've got an example in I7 of what I'm thinking, but it has a couple problems. This is the formula I have:

Please Login or Register  to view this content.

Main issues are that I'm not sure how to display text from multiple cells in the output, and that this is just searching one cell, not the entire sheet.

Any help would be greatly appreciated!!Excel Example.xls

Bump Bump.

I got the formula figured out so that it displays correctly for one item, but I'm still struggling to make it work for multiple items. This is what I have now

Please Login or Register  to view this content.

Even if it was just a separate formula for each column I could make it work. So it would basically search everything in column B, and for anything due today, output B1+ the corresponding report in column A.

Thanks, but that's not exactly what I'm shooting for. The formula I have checks if the date in B7 is today and then checks if there is an 'x' in C7. If both of those are met, it outputs the name from B1 (John Smith), and the report name from A7 (Process Report), so the output would be "John Smith: Process Report". That part works exactly like I want it - I just want it to check all of the cells in Column B. So for the way I have it now, it should output all three reports due today: "John Smith: Process Report John Smith: Report 1 John Smith: Report 2".

That's still just pulling one result for me

Yes, sorry. The condition is not an 'x'. But the formula is still only outputting one result. Maybe I'm not being clear on what I want. I need a single cell to output the results for the entire column - I don't want a separate formula for each one. So say I put this formula in I7... it would check every date in column B to see if it was today, then would check if there was an x next to any of those dates, and if not, it would output every single report due today. So the way I have the sample sheet (change the admission date for John Smith to 2/10 and it will adjust the due dates accordingly) there are three items that meet that criteria: Process Report, Report 1, and Report 2. So the output in I7 would be "John Smith: Process Report John Smith: Report 1 John Smith: Report 2".

Thanks for your help and your quick replies!

Any other ideas on this? It doesnt have to be done the way I'm describing - really all I want is to create a sheet at the beginning that pulls any item due today. Doesnt matter how its accomplished as long as it works.