VLookup for multiple occurences of a value

[chris.slater]

Hi Guys
In my worksheet I have a Master Tab containing a list of data consisting of Codes in one column and a description in the 2nd. The codes appear multiple times, each time with a different description.
My worksheet also has multiple tabs each one relating to one of the codes.
I have a cell in each tab which displays the code and I want to compile a list of all the descriptions relating to each code within it's corresponding tab.
If I used VLookup it would only return the first instance of the code. I want to use the cell reference in each tab to perform a lookup and return all of the descriptions for every instance of that code in the Master Tab.
I have attached an example worksheet to, hopefully, show you what I mean.
thanks everyone.
Stay safe
regards
Chris

[Fluff13]

How about, in A2 copied down
=IFERROR(INDEX('Master Tab'!$B$2:$B$100,AGGREGATE(15,6,(ROW('Master Tab'!$B$2:$B$100)-ROW('Master Tab'!$B$2)+1)/('Master Tab'!$A$2:$A$100=B$1),ROWS(A$2:A2))),"")