Announcement

Collapse
No announcement yet.

Search range for 1 of 3 different criteria return nth result

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.



    Attached Files

  • #2


    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))

    Comment

    Working...
    X