Hi there,

here is my problem: I have different groups of Airlines (like Lufthansa, United...) and each group contains a "table":
- in rows are the flight classes (Q,V,T...in C3, C4, C5 for example)
- in columns are the fidelity program (M&M, Bonus, Smiles...in D2,E2,F2)

The intersection of each provides me the awarded mileage in % (like 50%, 75%, 100%...).

I want to enter in A20 the Airline name, in A21 the Class, and in A22 the fidelity program...and in return I get in A23 the awarded mileage (= intersection of the Class and the fidelity program... in the right table).

I tried the following, but it twisted my brain for too long... and I cannot resolve this anymore, somehow.

=INDEX(OFFSET(INDIRECT(CELL("address",INDEX(A1:AB1,MATCH("EVA AIR",A1:AB1,0)))),3,-1,20,1):BA41,MATCH("Q",OFFSET(INDIRECT(CELL("address",INDEX(A1:AB1,MATCH("EVA AIR",A1:AB1,0)))),3,-1,20,1),0),MATCH("M&M",OFFSET(INDIRECT(CELL("address",INDEX(A1:AB1,MATCH("EVA AIR",A1:AB1,0)))),2,0,1,2),0)+1)

Any idea ?

Thank you.

Nikox