Extract data to multiple rows based on value in separate cell

Hi all,

I'm familiar with basic Excel but after 6 hours this is just beyond me It should be straightforward but I've been trying every formula I could find and I just can't get it right.

What I want is for when I change the Call Time on the LO Security sheet (D8), for it to auto-populate the names in list form in column B under Name.

The names come from the Employees sheet column B and should correspond to the call time on the same sheet in column E.

ie. when I put in 7:00 AM on the LO Security sheet, it should look on the Employees sheet and pull every name that should be in at 7:00 AM according to the Call Time on the Employees sheet.

The best I've gotten so far are blanks and #NUM errors.

I've included a sanitized workbook with the relevant sheets.

Thanks in advance!

This should do it:

Please Login or Register  to view this content.

It is array entered, meaning that you will have to use Ctrl+Shift+Enter instead of Regular Enter.
I've used only the ranges of data found in Employees. Change them in your file

Thanks a lot! It did mostly what I need it to do. I am encountering one hiccup though. If I have in the list as x time, x time, x time, y time, x time it will stop after the third x time and not return anything for the 4th. Is there a way around it as the times will vary per name and may not always be contigous. There also may be blank rows in between the names. I've included a workbook example. The 4th 7:00 AM name is Employees B9 and I notice I get and error warning on LI Security B8 that says - The formula in this cell refers to a range that has additional numbers adjacent to it.

Thank you.

Try this. It will return all results that match the criteria, even if there are blanks:

Please Login or Register  to view this content.