You 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,
Elkar


"Brian" wrote:

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?

Thanks