| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help- Lookup table
I am trying to create a lookup table for a calculator I am creating in excel.
I need the calculator to look up a deration factor based on both the altitude and the temperature. For instance, if I put in a temperature that falls in the range of 50 to 60 degrees fahrenheit and a altitude falls in the range of 0 to 1000 feet, I need excel to tell me that my deration factor is 1.00. However, if I put in a temperature that is above 130 with an altitude of 3000 to 4000 feet I need Excel to tell me that my deration is 0.98. Is there a method or formula that would allow me to accomplish this task? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Table Lookup formula where 2 known values are inside array | New Users to Excel | |||
| What formula can I set up to do a cross lookup in an Excel table? | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| formula to lookup table in another Worksheet please | Excel Worksheet Functions | |||
Threaded Mode
