| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Base | Excel Discussion (Misc queries) | |||
| update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
| How do I decile a data base, is there a formula that I can use? | Excel Discussion (Misc queries) | |||
| how do I print data in a spreadsheet data base to a mailing lable. | Excel Discussion (Misc queries) | |||
| how do I print data in a spreadsheet data base to a mailing lable. | Excel Discussion (Misc queries) | |||
Hybrid Mode
