Combine columns and remove zero's/errors

[twasp]

Hello!

I am trying to combine multiple index matches to allow for multiple criteria and multiple matches.
I have all my matches take place separately from where the index occurs in specific columns for each of the parameters it is matching.
I want to add all of the different matches (row numbers) into one column but remove any zeros which appear due to N/A errors.
Doing this i will be able to index from the new column which will let me use multiple criteria to index match.
Currently any cells that do not contain matched values will return an N/A in the match column and in the column where all the match columns are pieced together these n/a errors become 0's
I want to remove this as the column becomes too long for me to index.
How can i do this?

EDIT - Please see the attached example

This is one of my match formulae

=MATCH($B$3,OFFSET(Data_Sheet!$C$5,Lookup_Sheet!Y11,,140),0)+Lookup_Sheet!Y11

This is the formulae that pieces together all of the match columns

=OFFSET($Y$12,(ROW()-ROW($AH$11)-1)-(ROW($Y$151)-ROW($Y$12)+1)*ROUNDDOWN((ROW()-ROW($AH$12)-1)/(ROW($Y$151)-ROW($Y$12)+1),0),ROUNDDOWN((ROW()-ROW($AH$11)-1)/(ROW($Y$151)-ROW($Y$12)+1),0))

This is my index formulae (currently using switch's but this will be changed if i can get this single column idea to work)

=IFERROR(SWITCH($F$7,1,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$Y12),2,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$Z12),3,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$AA12),4,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$AB12),5,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$AC12),6,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$AD12),7,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$AE12),8,INDEX(Data_Sheet!C$5:C$144,Lookup_Sheet!$AF12)),"")