Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up both row and column to give a third value
Hi All,
I have a spreadsheet similar to: The first column is the pressure, the first row is the specific gravity, and the rest of the table is the density at each pressure and specific gravity. 0 0.5 1.0 20 0 1.0 2.0 10 0 0.8 1.5 0 0 0.6 1.4 I wish to input a pressure and specific gravity and interpolate what the density will be. e.g. for 16 pressure and 0.7specific gravity, what will the density be? Cheers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up both row and column to give a third value
hi
please send me email and I will send you the answer. kwongyauleung at hotmail dot com. "CameronM" wrote: Hi All, I have a spreadsheet similar to: The first column is the pressure, the first row is the specific gravity, and the rest of the table is the density at each pressure and specific gravity. 0 0.5 1.0 20 0 1.0 2.0 10 0 0.8 1.5 0 0 0.6 1.4 I wish to input a pressure and specific gravity and interpolate what the density will be. e.g. for 16 pressure and 0.7specific gravity, what will the density be? Cheers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up both row and column to give a third value
Hi Cameron
Try this =INDEX(B2:D4,MATCH(F1,A2:A4,0),MATCH(G1,B1:D1,0)) F1 is the Pressure you want to lookup and G1 is Specific Gravity The Index function is your density table, first Match is your pressure column, second match is your gravity row. You will need to adjust range to your needs. HTH John "CameronM" wrote in message ... Hi All, I have a spreadsheet similar to: The first column is the pressure, the first row is the specific gravity, and the rest of the table is the density at each pressure and specific gravity. 0 0.5 1.0 20 0 1.0 2.0 10 0 0.8 1.5 0 0 0.6 1.4 I wish to input a pressure and specific gravity and interpolate what the density will be. e.g. for 16 pressure and 0.7specific gravity, what will the density be? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Find a row give me a column | Excel Discussion (Misc queries) | |||
Look up a value in one column and give a corresponding value | Excel Discussion (Misc queries) | |||
How can give the same name to a row or column in different sheets. | Excel Discussion (Misc queries) | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions |