What command to use?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Swyne - 27 Nov 2006 04:36 GMT

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

Reply to this Message

Max - 27 Nov 2006 04:59 GMT

One way ..

Assuming source table in cols A to C,
listed in B2:C2 are: 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))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I have some data in columns and just can't seem to find the right command to
> use.
[quoted text clipped - 31 lines]
> burnt
> which I wanna get fron the table

Reply to this Message

Max - 27 Nov 2006 05:39 GMT

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))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Max - 27 Nov 2006 06:23 GMT

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))

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Swyne - 27 Nov 2006 13:59 GMT

Thanx a million Max

> 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))

Reply to this Message

Max - 27 Nov 2006 14:29 GMT

You're welcome !

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thanx a million Max

Reply to this Message