Index or Pivot Table

[melbwarrior]

Hi All

Please could help be provided with the following.

I am trying search for a value in the Name Column - in this instance ABCD and at each occurrence return the entire row associated with ABCD

Sample data

[TABLE="width: 539"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Thing 1[/TD]
[TD]Thing 2[/TD]
[TD]Thing 3[/TD]
[TD]Thing 4[/TD]
[TD]Thing 5[/TD]
[TD]Thing 6[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD]ada[/TD]
[TD]dasd[/TD]
[TD]asdadasd[/TD]
[TD]fsds[/TD]
[TD]asda[/TD]
[TD]fasa[/TD]
[/TR]
[TR]
[TD]DEFG[/TD]
[TD]sdadasd[/TD]
[TD]afadadas[/TD]
[TD]asdadasd[/TD]
[TD]dsasd[/TD]
[TD]asdad[/TD]
[TD]asdad[/TD]
[/TR]
[TR]
[TD]HJKL[/TD]
[TD]ada[/TD]
[TD]asd[/TD]
[TD]sd[/TD]
[TD]sd[/TD]
[TD]asd[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD]d[/TD]
[TD]asd[/TD]
[TD]asdadasd[/TD]
[TD]a[/TD]
[TD]asd[/TD]
[TD="align: right"]513[/TD]
[/TR]
[TR]
[TD]HJKL[/TD]
[TD]a314[/TD]
[TD="align: right"]1[/TD]
[TD]asdadasd[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]21[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]HJKL[/TD]
[TD]sdadasd[/TD]
[TD]afadadas[/TD]
[TD]asdadasd[/TD]
[TD]dsasd[/TD]
[TD]asdad[/TD]
[TD]asdad[/TD]
[/TR]
[TR]
[TD]ABCD[/TD]
[TD]ada[/TD]
[TD]asd[/TD]
[TD]sd[/TD]
[TD]sd[/TD]
[TD]asd[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]WXYZ[/TD]
[TD]d[/TD]
[TD]asd[/TD]
[TD]asdadasd[/TD]
[TD]a[/TD]
[TD]asd[/TD]
[TD="align: right"]513[/TD]
[/TR]
[TR]
[TD]DEFG[/TD]
[TD]dasd[/TD]
[TD]aedfd[/TD]
[TD]klk[/TD]
[TD]ada[/TD]
[TD]ada[/TD]
[TD]asdad[/TD]
[/TR]
</tbody>[/TABLE]

I have tried index matching and vlook but I can't my silly brain around it

Thanks in advance