Multiple Match/Index for Individual Tabs

Originally Posted by Pete_UK

You can put this in D2 of the Rep_Sheet:

=IF(B2="","-",B2&"_"&COUNTIF(B$2:B2,B2))

Copy down as far as you wish to (the hyphens will show where the formula is active, to help you cope with new data being added).

Then you can put this formula in A3 of the subsidiary sheets:

=IFERROR(INDEX('Rep Sheet'!A:A,MATCH($A$1&"_"&ROWS($1:1),'Rep Sheet'!$D:$D,0)),"")

Copy across and down, as required.

Note: you will need to change the name in cell A1 of the Hart sheet.

Hope this helps.

Pete

What do I need to change the name to in A1? Im a bit confused.