data validation problem

hi

what i want is the following
1- suppose i insert the aircraft registration in cell b7 (jyayv)
2- fuel density in b9 (2.88)
3- the data validation in cell b8 should do the following
a- identify the aircraft type from table f5:g33 ( b7=jyayv then from said table the aircraft type is A321)
b- from table i4:s48 find fuel density 2.88 column and maximum fuel entered should be 20500. if fuel density
is changed to 2.91 them max. fuel should be 21000 again if we change fuel density to 3.03 then max. fuel
is 21500 and so forth.
same logic should be applied to all aircraft registration

thank you much

fuel.xlsx

I would put all of your "tables" on separate worksheets within the workbook first, then use VLookup to popluate the fields based on the registration number... Sorry I don't have time to update your sheet to show you how its done right now, I may get a chance to after I leave work today.

Made a mod to you file (using merged cells may look nice but Excel has serious problems working with these) and used the vlookup function to identify aircraft.

Not sure I understand the rest of your problem. I'm also a bit puzzled by the fuel density as aviation turbine kerosene has a density in the range of
0.77 to 0.79 g/cm3

Alf

after identifying the correct aircraft type ( in this case A321) should go to the appropriate table ( in this case a321 ) and based on the the fuel density the maximum fuel ammount can be accepted in cell b8
if fuel density 2.88 max. fuel should not exceed 20500
2.91 then max. fuel should not exceed 21000 and so on.
regarding fuel density it can be measured in three ways

Fuel Density

NO. kg/L Kg/ USG LB/ USG

1 0.76 2.88 6.34
2 0.77 2.91 6.43
3 0.78 2.95 6.51
4 785 2.97 6.55
5 0.79 2.99 6.59
6 0.8 3.03 6.68
7 0.81 3.07 6.76
8 0.82 3.1 6.84

i did acheive my goal but these are the final fine tunes if i could acheive woud be better.

thank you much