If I have a range like this in columns A-C -
A B C
1 2 34.6
1 3 5.3
1 4 19.7
1 5 8.6
1 6 17.3
1 7 7.6
1 8 8.1
2 3 0
2 4 138
2 5 0
2 6 0
2 7 138
2 8 138
3 4 46.1
3 5 15.3
3 6 69.2
3 7 9.8
3 8 12.5
4 5 138
4 6 138
4 7 69.2
4 8 0
And in range d2:e2 I have this
D E
3 7
How do I lookup that 3 7 and return the value corresponding, ie 9.8?
A B C
1 2 34.6
1 3 5.3
1 4 19.7
1 5 8.6
1 6 17.3
1 7 7.6
1 8 8.1
2 3 0
2 4 138
2 5 0
2 6 0
2 7 138
2 8 138
3 4 46.1
3 5 15.3
3 6 69.2
3 7 9.8
3 8 12.5
4 5 138
4 6 138
4 7 69.2
4 8 0
And in range d2:e2 I have this
D E
3 7
How do I lookup that 3 7 and return the value corresponding, ie 9.8?