In a excel formula I need to create a list of names on one sheet based upon criteria data of another sheet

Question

I have two sheets: the first is a running operation report that updates people and workflow performance throughout the day, and the second is just data on the staff and the expected workload for the day. I require an excel formula that will search the list of employees in "column B" of the data sheet and extract a list of names according to their availability status in "column A" of the data sheet. There are other statuses, but I simply need "Aval" at this time. The names must then be entered into "column I" of the operations sheet in a columnar style, with no blank spaces or double entries.

Any help would be appreciated.

Answer 1

The final formula is:

 =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel!$B$3:$B$150,AGGREGATE(15,3,(Personnel!$A$3:$A$150='Screen Display'!$I$3)/(Personnel!$A$3:$A$150='Screen Display'!$I$3)*(ROW(Personnel!$A$3:$A$150)-ROW(Personnel!$A$2)),ROWS($H$3:H3))),"")