how can interpolate the following

[nader assaleh]

hi
can i apply interpolation to the following situation (i did try many many times but i couldnt)

AIRCRAFT REGISTRATION
JYAIA
FUEL QUANTITY 28400
FUEL DENSITY 3.08

THEN FUEL INDEX IS -21

i want to find way to let excel take the next fuel quantity from the table (29000)
and get its fuel index value -24 and interpolate them....
thank you nuch

 

[Luke M]

You should give Debraj and SirJB7 a chance to answer you previous thread before starting a new one please. Posting redirect link:
http://chandoo.org/forum/threads/vlookup-question.15978/#post-96986
and closing this thread.