| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What command to use?
I have some data in columns and just can't seem to find the right command to
use. My data currently looks like this Sector Block Fuel Destination DHC-8 311 DHC-8 102 AXA 875 760 BGI 1760 1530 DOM 865 730 EIS 1335 1145 FDF 1210 1000 GND 2100 1750 NEV 650 600 POS 2450 2100 PTP 575 510 SDQ 2650 2500 SJU 1750 1500 SKB 575 510 SLU 1400 1230 STT 1420 1250 STX 1310 1130 SVD 1690 1460 SXM 850 720 TAB 2285 1930 UVF 1420 1250 and in two other cells I have Destination AXA A/C Type DHC-8 311 Burn-off unknown based on the aircraft type and the destination a certain amount of fuel is burnt which I wanna get fron the table |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What command to use?
One way ..
Assuming source table in cols A to C, listed in B2:C2 a DHC-8 311, DHC-8 102 and listed in A3 down are the destinations: AXA, BGI, etc, Then in say, E2:F4 are Destination: AXA A/C Type: DHC-8 311 Burn-off: ? To get the burn-off, place in F4: =INDEX(C:C,MATCH(F2,A:A,0),MATCH(F3,$B$2:$C$2,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Swyne" wrote: I have some data in columns and just can't seem to find the right command to use. My data currently looks like this Sector Block Fuel Destination DHC-8 311 DHC-8 102 AXA 875 760 BGI 1760 1530 DOM 865 730 EIS 1335 1145 FDF 1210 1000 GND 2100 1750 NEV 650 600 POS 2450 2100 PTP 575 510 SDQ 2650 2500 SJU 1750 1500 SKB 575 510 SLU 1400 1230 STT 1420 1250 STX 1310 1130 SVD 1690 1460 SXM 850 720 TAB 2285 1930 UVF 1420 1250 and in two other cells I have Destination AXA A/C Type DHC-8 311 Burn-off unknown based on the aircraft type and the destination a certain amount of fuel is burnt which I wanna get fron the table |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What command to use?
Correction to earlier formula in F4, sorry:
To get the burn-off, place in F4: =INDEX(C:C,MATCH(F2,A:A,0),MATCH(F3,$B$2:$C$2,0)) In F4 should be: =INDEX(OFFSET(A:A,,MATCH(F3,$B$2:$C$2,0)),MATCH(F2 ,A:A,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What command to use?
Correction to earlier formula in F4, sorry:
To get the burn-off, place in F4: =INDEX(C:C,MATCH(F2,A:A,0),MATCH(F3,$B$2:$C$2,0)) In F4 should be: =INDEX(OFFSET(A:A,,MATCH(F3,$B$2:$C$2,0)),MATCH(F2 ,A:A,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What command to use?
Thanx a million Max
"Max" wrote: Correction to earlier formula in F4, sorry: To get the burn-off, place in F4: =INDEX(C:C,MATCH(F2,A:A,0),MATCH(F3,$B$2:$C$2,0)) In F4 should be: =INDEX(OFFSET(A:A,,MATCH(F3,$B$2:$C$2,0)),MATCH(F2 ,A:A,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What command to use?
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Swyne" wrote in message ... Thanx a million Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
