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, along with an example of the preferred format for the receiving end.

    Thanks in advance.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!