|
|
The
following formula returns a value from C3:E6, where the
corresponding value in B3:B6 equals the value in G2,
and corresponding value in C2:E2 equals the value in
H2...
=INDEX(C3:E6,MATCH(G2,B3:B6,0),MATCH(H2,C2:E2,0))
Based on the sample data, the formula returns 35. Sample
Workbook |
|
|
