formula for data base
 

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

formula for data base
 

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rod" wrote:
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

formula for data base
 

Thank You I appreciate all your help

"Max" wrote:

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rod" wrote:
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

formula for data base
 

welcome, Rod.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rod" wrote in message
...
Thank You I appreciate all your help