Aircraft Takeoff Data

[mikeba]

Hi,
I'm looking to create an excel sheet to return a set of numbers corresponding to take off data where the user will enter the aircraft weight and outside temperature.
Here is what the data tables look like in the performance charts...example below.

I need excel to find the closest match to the user input of Temp and Weight and return the column of data corresponding to the next higher values for both.
Example: Outside temp is 23*F and aircraft weight today is 1400 lbs. I need the formula to use the next higher temperature and weight, so for the example listed it would give me the data for 30*F and 2,000 lbs.

Thanks for any suggestions,

Mike


10*F 20*F 30*F 40*F

1000 lbs 44 46 50 57
56 50 54 62
66 62 64 76
120 122 125 130
3,223 3,455 3,655 3,778

2000 lbs x x x x
x x x x
x x x x
x x x x
x x x x

 

[mikeba]

This is the table of aircraft data....sample.

 

[alansidman]

Please use XL2BB to demo your data and for your examples show a mocked up solution. Cannot manipulate data in a picture and there is no relationship to an excel spreadsheet in your picture.

 

[mikeba]

Thanks,

I have resolved my issue.

 

[Fluff]

In future please do not mark a post as the solution if it does not contain one. Thanks

 

[mikeba]

My apologies on that.

Thank you,

Mike