Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up with 2 factors
I have a table that shows multiple gravity factors for each degree of
temperature as an example. 38 38.5 39 39.5 (Gravity) 40 degrees 5 4 3 2 40.5 degrees 4 3 2 1 I need to lookup up the degrees and look up the gravity and the result be the intersection of the proper degree with the gravity. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look up with 2 factors
=INDEX($A$1:$E$5,MATCH(40.5,$A$1:$A$5,0),MATCH(38. 5,$A$1:$E$1,0))
should retrieve the correct value from the below table. You can change the values 40.5 and 38.5 to a cell reference A1 38 38.5 39 39.5 40 5 4 3 2 40.5 9 8 7 6 50 6 5 4 3 50.5 8 1 6 1 If this post helps click Yes --------------- Jacob Skaria "AMC" wrote: I have a table that shows multiple gravity factors for each degree of temperature as an example. 38 38.5 39 39.5 (Gravity) 40 degrees 5 4 3 2 40.5 degrees 4 3 2 1 I need to lookup up the degrees and look up the gravity and the result be the intersection of the proper degree with the gravity. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if senerios with 2 factors | Excel Discussion (Misc queries) | |||
ANOVA with two factors | Excel Worksheet Functions | |||
Multiply one value by many factors | Excel Worksheet Functions | |||
Multiple IF factors | Excel Worksheet Functions | |||
Excel - Discount Factors and NOV | Excel Worksheet Functions |