Currently I have a formula which returns the data I need EXCEPT when there is a repeated SKU number that I'm referencing. Then it simply returns the first SKU number reference every time.

Current Formula: =OFFSET(INDEX('Production Data'!M:M,MATCH('Raw Data'!$A4,'Production Data'!$A:$A,0)),2,0)

As you can see the SKU's are in column A, but the volumes are offset two rows from it in column M.

Is there a way to adjust my formula into one that can return multiple SKU's considering this formula is an array (I've barely worked with array formulas).

The formula below isn't an index match which is throwing me off.

<code>=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2))</code>

For instance, the index references the whole array. My array would be column A and column M.

I've tried to adjust the formula below to match my parameters. Wasn't sure where to plug in the offset and match functions though or if I even needed them still.

<code>=IF(ISERROR(INDEX(

**$A:$A & $M:$M**,SMALL(IF($A:$A=$A4,ROW($A:$A)),ROW(1:1)),13 or COLUMN M)),"",INDEX(

**$**

**A:$A & $M:$M**</code>,SMALL(IF($A:$A=$A4,ROW($A:$A)),ROW(1:1)), 13 or column M))I'm not even certain it will work or if I'll be able to drag it down to apply to other formulas because it's an array.Any advise appreciated.