software

I have a table that has Temps along the x axis and Altitude down the Y axis.
Whats a formula that would display the value in the cell where a given Alt
value and Temp value meet?

ThanksYou could combine the VLOOKUP and MATCH functions. Something like this,
depending how your table is setup.

=VLOOKUP(A1,B1:F100,MATCH(A2,B1:F100,0),FALSE)

With Altitude and Temp to find stored in A1 and A2.

HTH,
Elkarquot;Brianquot; wrote:

gt; I have a table that has Temps along the x axis and Altitude down the Y axis.
gt; Whats a formula that would display the value in the cell where a given Alt
gt; value and Temp value meet?
gt;
gt; Thanks
gt;

Thanks fo rthe respones but I'm not familar with those two functions, and am
can't fit what you provided into what I need.

So, with the table below, if 10-30 are column headers and 2000-7000 are row
headers, with a temp of 20 and a alt of 3500 given is there a formula that
will come up with the value 143 which is where the column and row intersect?

FYI the values in the table that are not headers will be random in the
actual table...1015202530
2000111112113114115
2500121122123124125
3000131132133134135
3500141142143144145
4000151152153154155
4500161162163164165
5000171172173174175
5500181182183184185
6000191192193194195
6500201202203204205
7000211212213214215

quot;Elkarquot; wrote:

gt; You could combine the VLOOKUP and MATCH functions. Something like this,
gt; depending how your table is setup.
gt;
gt; =VLOOKUP(A1,B1:F100,MATCH(A2,B1:F100,0),FALSE)
gt;
gt; With Altitude and Temp to find stored in A1 and A2.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; I have a table that has Temps along the x axis and Altitude down the Y axis.
gt; gt; Whats a formula that would display the value in the cell where a given Alt
gt; gt; value and Temp value meet?
gt; gt;
gt; gt; Thanks
gt; gt;

Take a lookup at this screencap:

img98.imageshack.us/img98/6248/lookup4tc.jpg

Formula #1 is for EXACT matches of the lookup values. That is, your lookup
values will always match the table headers like 3500 and 20.

Formula #2 is for the CLOSEST match that is less than or equal to the lookup
value. That is, the lookup values may or may not match the table headers
like 3722 and 27.

Biff

quot;Brianquot; gt; wrote in message
...
gt; Thanks fo rthe respones but I'm not familar with those two functions, and
gt; am
gt; can't fit what you provided into what I need.
gt;
gt; So, with the table below, if 10-30 are column headers and 2000-7000 are
gt; row
gt; headers, with a temp of 20 and a alt of 3500 given is there a formula that
gt; will come up with the value 143 which is where the column and row
gt; intersect?
gt;
gt; FYI the values in the table that are not headers will be random in the
gt; actual table...
gt;
gt;
gt; 10 15 20 25 30
gt; 2000 111 112 113 114 115
gt; 2500 121 122 123 124 125
gt; 3000 131 132 133 134 135
gt; 3500 141 142 143 144 145
gt; 4000 151 152 153 154 155
gt; 4500 161 162 163 164 165
gt; 5000 171 172 173 174 175
gt; 5500 181 182 183 184 185
gt; 6000 191 192 193 194 195
gt; 6500 201 202 203 204 205
gt; 7000 211 212 213 214 215
gt;
gt; quot;Elkarquot; wrote:
gt;
gt;gt; You could combine the VLOOKUP and MATCH functions. Something like this,
gt;gt; depending how your table is setup.
gt;gt;
gt;gt; =VLOOKUP(A1,B1:F100,MATCH(A2,B1:F100,0),FALSE)
gt;gt;
gt;gt; With Altitude and Temp to find stored in A1 and A2.
gt;gt;
gt;gt; HTH,
gt;gt; Elkar
gt;gt;
gt;gt;
gt;gt; quot;Brianquot; wrote:
gt;gt;
gt;gt; gt; I have a table that has Temps along the x axis and Altitude down the Y
gt;gt; gt; axis.
gt;gt; gt; Whats a formula that would display the value in the cell where a given
gt;gt; gt; Alt
gt;gt; gt; value and Temp value meet?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
Hi Brian!

As per example, supposing that we name the range 10 - 30 as quot;Tempquot;, the
range 2000 - 7000 as quot;Altquot; and the tabulated values as quot;dataquot; (excluding Temp
and Alt) would this formula help?

=INDEX(data,MATCH(X,Alt,0),MATCH(Y,Temp,0))

where X and Y are desired Alt and Temp values respectively.

Hope this helps!
--
Thanks and kind regardsquot;Brianquot; wrote:

gt; Thanks fo rthe respones but I'm not familar with those two functions, and am
gt; can't fit what you provided into what I need.
gt;
gt; So, with the table below, if 10-30 are column headers and 2000-7000 are row
gt; headers, with a temp of 20 and a alt of 3500 given is there a formula that
gt; will come up with the value 143 which is where the column and row intersect?
gt;
gt; FYI the values in the table that are not headers will be random in the
gt; actual table...
gt;
gt;
gt; 1015202530
gt; 2000111112113114115
gt; 2500121122123124125
gt; 3000131132133134135
gt; 3500141142143144145
gt; 4000151152153154155
gt; 4500161162163164165
gt; 5000171172173174175
gt; 5500181182183184185
gt; 6000191192193194195
gt; 6500201202203204205
gt; 7000211212213214215
gt;
gt; quot;Elkarquot; wrote:
gt;
gt; gt; You could combine the VLOOKUP and MATCH functions. Something like this,
gt; gt; depending how your table is setup.
gt; gt;
gt; gt; =VLOOKUP(A1,B1:F100,MATCH(A2,B1:F100,0),FALSE)
gt; gt;
gt; gt; With Altitude and Temp to find stored in A1 and A2.
gt; gt;
gt; gt; HTH,
gt; gt; Elkar
gt; gt;
gt; gt;
gt; gt; quot;Brianquot; wrote:
gt; gt;
gt; gt; gt; I have a table that has Temps along the x axis and Altitude down the Y axis.
gt; gt; gt; Whats a formula that would display the value in the cell where a given Alt
gt; gt; gt; value and Temp value meet?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt;

In addition to my post, be sure to have provisions within the spreadsheet to
place the X and Y values so that the indicated formula below can have valid
references.
--
Thanks and kind regardsquot;RaymundCGquot; wrote:

gt; Hi Brian!
gt;
gt; As per example, supposing that we name the range 10 - 30 as quot;Tempquot;, the
gt; range 2000 - 7000 as quot;Altquot; and the tabulated values as quot;dataquot; (excluding Temp
gt; and Alt) would this formula help?
gt;
gt; =INDEX(data,MATCH(X,Alt,0),MATCH(Y,Temp,0))
gt;
gt; where X and Y are desired Alt and Temp values respectively.
gt;
gt; Hope this helps!
gt; --
gt; Thanks and kind regards
gt;
gt;
gt; quot;Brianquot; wrote:
gt;
gt; gt; Thanks fo rthe respones but I'm not familar with those two functions, and am
gt; gt; can't fit what you provided into what I need.
gt; gt;
gt; gt; So, with the table below, if 10-30 are column headers and 2000-7000 are row
gt; gt; headers, with a temp of 20 and a alt of 3500 given is there a formula that
gt; gt; will come up with the value 143 which is where the column and row intersect?
gt; gt;
gt; gt; FYI the values in the table that are not headers will be random in the
gt; gt; actual table...
gt; gt;
gt; gt;
gt; gt; 1015202530
gt; gt; 2000111112113114115
gt; gt; 2500121122123124125
gt; gt; 3000131132133134135
gt; gt; 3500141142143144145
gt; gt; 4000151152153154155
gt; gt; 4500161162163164165
gt; gt; 5000171172173174175
gt; gt; 5500181182183184185
gt; gt; 6000191192193194195
gt; gt; 6500201202203204205
gt; gt; 7000211212213214215
gt; gt;
gt; gt; quot;Elkarquot; wrote:
gt; gt;
gt; gt; gt; You could combine the VLOOKUP and MATCH functions. Something like this,
gt; gt; gt; depending how your table is setup.
gt; gt; gt;
gt; gt; gt; =VLOOKUP(A1,B1:F100,MATCH(A2,B1:F100,0),FALSE)
gt; gt; gt;
gt; gt; gt; With Altitude and Temp to find stored in A1 and A2.
gt; gt; gt;
gt; gt; gt; HTH,
gt; gt; gt; Elkar
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Brianquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a table that has Temps along the x axis and Altitude down the Y axis.
gt; gt; gt; gt; Whats a formula that would display the value in the cell where a given Alt
gt; gt; gt; gt; value and Temp value meet?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt;