Return values from table
Max wrote:
An index/match could also be used ..
Assume your posted table is within A1:D4,
data in B2:D4, row headers in A2:A4, col headers in B1:D1
Assume you have the paired inputs in F2:G2 down,
eg in F2: Single, in G2: Termo
then you could place this in H2:
=INDEX($B$2:$D$4,MATCH(F2,$A$2:$A$4,0),MATCH(G2,$B $1:$D$1,0))
to return the intersection data, viz: 30
Copy H2 down to return correspondingly for other paired inputs in F3:G3,
F4:G4, etc
Definitely. A very nice scalable alternative.
|