Retrieve Data From Summary Sheet With Multiple Columns

[aluis]

Hello friends,

Kindly need your help, is it possible to create a Index and Match formula that goes through multiple fixed columns?

Thanks a lot and have a wonderful day.

 

[aluis]

This formula solve my problem, but it is to big and it is just a testing, the actual place where I am going to use it has at least 42 columns, so you can imagine how big the final formula will be, so I am looking for another way, maybe a smarter way to do it.

=IFERROR(INDEX(C11:C15,MATCH(D19,B11:B15,0)),IFERROR(INDEX(F11:F15,MATCH(D19,E11:E15,0)),IFERROR(INDEX(I11:I15,MATCH(D19,H11:H15,0)),"Unavailable")))

Please consider that the database I am retrieving is not able to be moved or modified since it is summarize automatically in that format.

Thanks a lot for your help in advance.