ExcelBanter - What command to use?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - What command to use? (https://www.excelbanter.com/excel-worksheet-functions/120191-what-command-use.html)

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

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

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

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

What command to use?

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Swyne" wrote in message
...
Thanx a million Max