Help with multiple value search and return using index match

[Engine1911]

Hi all,

First time posting. So I am creating a manpower document for our firehouse. The simple explanation of it is, one master sheet that has everyone's names in column A ad monthly dates in rowA A . At the intersections are drop down menus with specific values to designate on shift, off shift, overtime, leave, etc.. Then I have individual sheets for each day of the month which pull data from the master sheet and assign personnel accordingly. Currently I have a macro that will search for a value from a designated cell (example "T") and list the names in the cells I have assigned in descending order. What I am looking for is the ability to also have it return names that have other values such as "OT" or "TT". Is this possible? Here is the macro I am currently using:

=IF(ISERROR(INDEX(Master!$B$6:$B$78,SMALL(IF(Master!$C$6:$C$78=Master!$AI$2,ROW(Master!$C$6:$C$78)),ROW(1:1))-5)),"",INDEX(Master!$B$6:$B$78,SMALL(IF(Master!$C$6:$C$78=Master!$AI$2,ROW(Master!$C$6:$C$78)),ROW(1:1))-5))

 

[Engine1911]

Bump