Complex tabel lookup

Hello all,

I have a question regarding table look-ups. I have a table with data in it, the horizontal header (first row) has a series of pressure value's in it. The vertical first column has a series of temperatures in it. The rest of the table is filled with enthalpy values. I hope you all understand this.
Now, let's say I have a pressure and an enthalpy value. How can I return the corresponding temperature value, which are in the first column?
Is it possible at all with a normal function or functions in excel?


Thanks in advance,
Gert

Can you tell us which cells you are using, rather than us guessing and you having to change them?

Pete

Hi
perhaps post a small sample sheet ? Terms like " enthalpy" are not really Excel terms...

Originally Posted by arthurbr

Hi
perhaps post a small sample sheet ? Terms like " enthalpy" are not really Excel terms...

I doesn't really matter if it is "enthalpy" or anything else, it's just numbers in the end.

example sheet.xlsx

I hope this works.

And where will you enter your pressure and enthalpy values?

Pete

Originally Posted by Pete_UK

And where will you enter your pressure and enthalpy values?

Pete

They're already there, the top row is the pressure. The left column are temperatures with increments of 10°C. And the enthalpy values are the rest.
Now how can I look up a temperature, return it in another cell outside the table, if I have a pressure and an enthalpy value.

I hope you understand it.
Gert

Of course I understand it !! You said this:

another cell outside the table, if I have a pressure and an enthalpy value

and I asked which cells you were going to enter those values into. Assume you put Pressure in P1, Enthalpy in P2, then use this formula in P3:

Formula:

Please Login or Register  to view this content.

Hope this helps.

Pete

Originally Posted by Pete_UK

Of course I understand it !! You said this:



and I asked which cells you were going to enter those values into. Assume you put Pressure in P1, Enthalpy in P2, then use this formula in P3:

Formula:

Please Login or Register  to view this content.

Hope this helps.

Pete

Exactly what I wanted!

Thank you very much.
Gert

Originally Posted by shg

Would you want something that does interpolation?

Thank you, I will take a closer look at it tomorrow :D

Gert