I am trying to pull from a database with multiple columns and match criteria to vertical rows. Here is my formula.

=IFERROR(INDEX(name,MATCH(1,($B$1=INDEX(Table1, ,$C$1))*($A$4=shift)*(B$5=unit)*($A$6=job),0)),)

My data is pulling correct information but only one value when multiple values exist. How could I add a SMALL function to this formula?