2-dimensional lookup

[Guest]

Master list of data
DR AB TT
1 X1 n1
2 X2 n12
3 X3 n23
4 X4 n34
5 X5 n45
1 X2 n2
2 X3 n13
3 X4 n24
4 X5 n35
5 X1 n41
1 X3 n3
2 X4 n14
3 X5 n25
4 X1 n31
5 X2 n42
1 X4 n4
2 X5 n15
3 X1 n21
4 X2 n32
5 X3 n43
1 X5 n5
2 X1 n11
3 X2 n22
4 X3 n33
5 X4 n44

My data list:
AB DR TT
X1 1
X1 2
X2 3
X4 3
X3 4
X2 1
X5 2

How to fill column TT based on the master list?

 

[Biff]

Assume the master list id in the range A2:C26.

The data list is in the range E2:F8

Enter this formula as an array in G2 using the key combination of
CTRL,SHIFT,ENTER (not just ENTER):

=INDEX(C$2:C$26,MATCH(1,(A$2:A$26=F2)*(B$2:B$26=E2),0))

Copy down as needed.

Biff