Wildcard used in vlookup to return all matches

[fontae922]

I am using a vlookup with a wild card see below

=IFERROR(VLOOKUP("*"&TEXT(C8,"0")&"*",invoices!A:AF,5,FALSE),"N/A")

how can i make this return all values foundduring the look up.
I currently have a count feature set up which returns how many possible matches vlookup has located but i want to display the matches not just
count them count formula is listed below

=IFERROR(COUNTIF(invoices!A:A,"*"&TEXT(C8,"0")&"*"),"N/A")

is it possible to have the results list onto another sheet?