help is needed

[NADERASSALEH]

dears,
i have a question with many variable i will try to express myself
1- aircraft type
A319 JYAYN
JYAYM
JYAYN
JYAYP

A320 JYAYR
.....
....
JYAYX

A321 JYAYK
.....
A330 JYAIE
....
JYAIG

A340 JYAIA
.....
JYAID

BASED ON AIRCRAFT REGISTRATION AND FUEL FIGURES AND FUEL DENSITY I WANT TO PICK UP THE CORRECT FUEL EFFECT. I COULD DO IT FOR ANY PARTICULAR AIRCRAFT BUT HOW TO INCLUDE THE FUEL DENSITY IN THE FORMULA

=VLOOKUP($C$7,CHOOSE(VLOOKUP($C$6,CHOOOSE,3,FALSE),FUEL.A319,FUEL.320,FUEL.A321,FUEL.340.AB,FUEL.330),2)

$C$7= FUEL FIGURE
$C$6= AIRCRAFT REGISTRATION

fuel a330
S.G (kg/L)	0.775	0.78	0.785	0.79	0.795	0.8	0.805	0.815
WEIGHT (KG)	TOTAL TAKE-OFF FUEL INDEX
0	0	0	0	0	0	0	0	0
2000	997	997	997	997	997	997	997	997
4000	995	995	995	995	995	995	995	995
6000	992	992	992	992	992	992	992	992
8000	990	990	990	990	990	990	990	990
10000	990	990	990	990	990	990	990	990
12000	995	995	995	995	995	995	995	995
14000	1	1	1	1	1	1	1	1
16000	2	2	2	2	2	2	3	3
18000	999	999	0	0	0	0	0	0
20000	997	997	997	997	998	998	998	998
22000	995	995	995	995	995	995	995	996

<tbody>
</tbody>

A340 FUEL FIGURES BASED ON FUEL DENSITY

S.G (kg/L)	0.773	0.779	0.785	0.791	0.797	0.803	0.809	0.815
WEIGHT (KG)	TOTAL TAKE-OFF FUEL INDEX
0	0	0	0	0	0	0	0	0
1000	-2	-2	-2	-2	-2	-2	-2	-2
2000	-5	-5	-5	-5	-5	-5	-5	-5
3000	-8	-8	-8	-8	-8	-8	-8	-8
4000	-10	-10	-10	-10	-10	-10	-10	-10
5000	-13	-13	-13	-13	-13	-13	-13	-13
6000	-16	-16	-16	-16	-16	-16	-16	-16
7000	-18	-18	-18	-18	-18	-18	-18	-18
8000	-21	-21	-21	-21	-21	-21	-21	-21
9000	-23	-23	-23	-23	-23	-23	-23	-23
10000	-19	-19	-19	-19	-19	-19	-19	-19
11000	-14	-14	-14	-14	-14	-14	-14	-14
12000	-9	-9	-9	-9	-9	-9	-9	-9
13000	-4	-4	-4	-4	-4	-4	-4	-4
14000	3	3	2	2	2	2	2	2
15000	7	7	7	8	8	8	9	9
16000	4	4	5	5	5	6	6	6

<tbody>
</tbody>

SORRY FOR MY BAD ENGLISH LANGGUAGE AS IT IS NOT MY MOTHER TONGUE.

 

[etaf]

how many of these plans figures do you have

you can use a lookup to lookup in the grid

do you have the weight and S.G (kg/L) and then looking up in the grid for a value ?

then you could use an indirect() to call which sheet to lookup depending on aircraft type

BUT i'm not 100% certain how you are using the grid and what you are looking up ?

 

[NADERASSALEH]

DEARS,
iam trying to write a formula to give me fuel figures' effect or index based on the the amount of fuel onboard and fuel density and aircraft type. i could write a formula but it give fuel index for one type of density

=VLOOKUP($C$7,CHOOSE(VLOOKUP($C$6,CHOOOSE,3,FALSE),FUEL.A319,FUEL.320,FUEL.A321,FUEL.340.AB,FUEL.330),2)

$c$7 = fuel figure
$c$6 = aircraft registration



Below is aircraft registration

aircraft regstration	aircraft type	aircraft type
JYAYK	A321	1
JYAYJ	A321	1
JYAYT	A321	1
JYAYV	A321	1
JYAIE	A330	2
JYAIF	A330	2
JYAIG	A330	2
JYAIA	A340	3
JYAIB	A340	3
JYAIC	A340	3

<tbody>
</tbody>

below table for A340 aircrafts fuel.340.ab table

fuel den	.773	.779	.785	.797	.803	.809	.815
weight
500	-1	-2	-2	-2	-2	-2	-2
1000	-3	-2	-2	-2	-4	-4	-4
1500	-2	-3	-3	-3	-3	-3	-3
2000	0	0	0	0	0	0	0
2500	1	1	1	1	1	1	1
3000	1	1	1	1	1	1	1
3500	2	2	2	2	1	1	1

<tbody>
</tbody>

below fuel index for A330 aircrafts. FUEL.A330

fuel den.	.775	.780	.785	.790	.795	.80	.805	.815
weight	3	3	3	3	3	3	3	3
2000	5	5	5	5	5	5	5	5
4000	8	8	8	7	7	7	6	6
6000	5	5	5	4	4	4	4	4
8000	1	1	1	1	1	1	1	1
10000	0	0	0	0	0	0	0	0
12000	-1	-1	-1	-1	-2	-2	-2	-2

<tbody>
</tbody>

below fuel index for A321 aircfafts FUEL.A321 TABLE

fuel den.	.76	.77	.78	.785	.79	.80	.81	.82
weight
1000	-1	-1	-1	-1	-1	-1	-1	-1
1500	-1	-1	-1	-1	-1	-1	-1	-1
2000	-2	-2	-2	-2	-2	-2	-2	-2
2500	-4	-4	-4	-4	-4	-4	-4	-4
3000	-2	-2	-2	-2	-2	-2	-3	-3
3500	-1	0	0	0	0	0	-1	-1
4000	1	1	1	1	1	1	1	1

<tbody>
</tbody>

 

[Rick Rothstein]

Same question as here...

http://www.mrexcel.com/forum/excel-questions/758055-your-help-badly-needed-solve-below.html