Return Multiple Values For a Single search

Originally Posted by FDibbins

OK try this...

in sheet1 F5, copied down...
=C5&" "&COUNTIFS($C$5:C5,C5,$E$5:E5,E5)&" "&E5

Then use a helper column in A, D, G etc for this...(you can format the text to white so it looks like its invisible)...
=IF(B5="",A4,B5)

And finally in C5, copied down and across to F, I L etc...
=IFERROR(INDEX(MasterList!$D:$D,MATCH(B$3&" "&COUNTIF(A$5:A5,A5)&" "&A5,MasterList!$F:$F,0),1),"")

Thank you!! This is exactly what I was trying to accomplish!!