VLOOKUP to return multiple cells of same lookup value

Hi, I am trying to create an automated receipt for a list of artists. I have given the artist an individual reference so I am doing a VLOOKUP to return description/price value etc but I can only get it to return the initial value and I have approx 10-15 works under each reference. Maybe VLOOKUP is the wrong formula to use.. I have attached the file - if some excel whizz out there can give me any ideas it would be a huge help!

thanks

Is the workbook password protected? Please unprotect it.

Please see attached,

What I did was add a helper column in the Log sheet to count the number of matches, using formula in U7: =COUNTIF(B$7:B7,Receipt!$F$10) copied down

Then I entered the max number in the main sheet in A16 with formula: =MAX('Art log'!$U:$U) this is to use to let excel know when to start displaying blanks because number of matches is less than number of rows occupied by the formulas.

Then in A18, used formula: =IF(ROWS($A$18:$A18)>$A$16,"",INDEX('Art log'!E$7:E$31,MATCH(ROWS($A$18:A18),'Art log'!$U$7:$U$31,0)))

copied down and across the table to extract all matches.

Adjust any ranges to suit your actual database.