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.