Sheet setup

How do you use index with multiple columns

if I do =INDEX(C2:C4,MATCH(INDEX(E6:E25,MATCH(B3,C6:C25,0)),B2:B4,0))


Then it works.. I get the name that I need.

but if I use

=INDEX(C2:C4&I2:I4&K2:K4,MATCH(INDEX(E6:E25&O6:25,MATCH(B3,C6:C25&P6:P26,0)),B2:B4&H2:H4&J2:J4,0))

So basically I have 2 columns with possible names. I need to search BOTH columns for the name and then look into the cell next to it to grab a NUMBER. Then Search 3 columns of names that will correspond ot that number and grab the name.

When I try the & with other cells it doesn't work properly. Could someone explain how to use INDEX/Match with multiple colums each section of the formula and return just one result