Search range for 1 of 3 different criteria return nth result

Hey everyone,

Plain and Simple - Looking for some help putting together a formula that will search a range for one of three different values (those values can either be defined, or cell references) then return the first match, then second, then third and so forth.

Reference- I create a schedule weekly that excel has proven to be very helpful in creating, the only downside is that the receiving end of the schedule prefers it in a clean PDF file thus i have a blank Publisher document with a grid table setup that i manual transfer information from excel over to.

I have attached a copy of the worksheet i am trying to put together with this formula,

Thanks in advance.

I assume i would use some version of the below formula, except im unsure how to instead of trying to match two criteria to match one of three criteria returning the first match

=INDEX("DATA RANGE", SMALL(IF(COUNTIF("VALUE 1", "POSSIBLE VALUE 1 RANGE")*COUNTIF("VALUE 2", "POSSIBLE VALUE 2 RANGE"), ROW("RESULT LOCATION")-MIN(ROW("RESULT LOCATION"))+1), ROW(A1)), COLUMN(A1))