formula for data base

[Rod]

I have a data base on sheet 2 that looks like this


DACS 833 834 835 836
chan 21-1 21-1 21-1 21-1
oc 21-1 21-1 21-1 21-2
son 1 2 3 1
SPAN 1 5 33 61 89
SPAN 2 6 34 62 90
SPAN 3 7 35 63 91
SPAN 4 8 36 64 92
SPAN 5 9 37 65 93
SPAN 6 10 38 66 94
SPAN 7 11 39 67 95

on sheet 3 I would like to put 833 in a1 and 3 in b1 and come up with 7

 

[Max]

on sheet 3 I would like to put 833 in a1 and 3 in b1 and come up with 7

One way

In Sheet3,

Put in say, C1:
=OFFSET(Sheet2!$A1,MATCH("Span
"&B1,Sheet2!$A:$A,0)-1,MATCH(A1,Sheet2!$1:$1,0)-1)

 

[Rod]

Thank You I appreciate all your help

One way

In Sheet3,

Put in say, C1:
=OFFSET(Sheet2!$A1,MATCH("Span
"&B1,Sheet2!$A:$A,0)-1,MATCH(A1,Sheet2!$1:$1,0)-1)

 

[Max]

welcome, Rod.