I am trying to match one value on a worksheet and return all products that match the value. Any item with the date MAT to 16/04/17 as well as type and return a list of items that match. When I use the formula the same item keeps appearing.
The formula I am using is =INDEX(Sheet3!$B$5:$B$1206, SMALL(IF(ISNUMBER(MATCH(Sheet3!$A$5:$A$606, $A$3, 0)), MATCH(ROW(Sheet3!$A$5:$A$606), ROW(Sheet3!$A$5:$A$606)), ""), ROWS(Sheet3!B5:B5)))
The formula I am using is =INDEX(Sheet3!$B$5:$B$1206, SMALL(IF(ISNUMBER(MATCH(Sheet3!$A$5:$A$606, $A$3, 0)), MATCH(ROW(Sheet3!$A$5:$A$606), ROW(Sheet3!$A$5:$A$606)), ""), ROWS(Sheet3!B5:B5)))
Last edited:
