0

I am trying to extract data from a worksheet using an array formula but it will only return one (the first it finds) value. The formula I am using is:

=INDEX($C$2:$C$8, SMALL(IF($B12=$B$2:$B$8, ROW($B$2:$B$8)-MIN(ROW($B$2:$B$8))+1, ""), 1)) found here

When I follow the example, I don't get the same result as the person that posted the answer. Could the formula have been "fat fingered"?

Community
  • 1
Frank Steinert
  • 1
  • 1
  • 1

1 Answers1

0

I use the following formula to return multiple values matching the same criteria.

{=IFERROR(INDEX([Return Value Range],SMALL(IF([Criteria Range]=[Criteria],ROW([Criteria Range])),ROW(1:1))),"")}

When you enter it, don't include the {} and remember that Array Formulas have to be entered by hitting Ctrl + Shift + Enter instead of just Enter. If you hit just Enter, it will only return the first result.

Fercstar
  • 141