The easiest way to do this is to use a helper column. Sort your data in Col A (data Sheet) so that the replications are next to each other.


Then insert a couple of columns before A.
In what is now Col B insert
=If(c2=c2,max($c$1:c2)+1,1)
Then in what is now col A simply join B&C
=b2&c2
This will give you a unique ref for each entry and then from this you can use your vlookup to search this unique ref to get the answers you need.

If you need a bit more help post an example and I will make it work for you

Matthew

Thanks Matthew but making a unique entry for each of the original targets won't work for me.

The target string I am looking for is supplied from a dropdown list (with unique entries) elsewhere in the spreadsheet.

What I'm aiming for is to select the target string from the dropdown and my first vlookup will find and select the data for the first entry (this much is straight forward). In the next row I then want to dynamically alter my Table_Array range to find the next instance of the same target string, and maybe the next again and so on until I have retrieved all entries of the target string. That way all of the entries in the list will be returned for the want of making the first dropdown selection - regardless of how many entries are in the list in the first place.