Multiple conditiions on data table HELP!!

[nostrum]

Hi,

See attached document, would really appreciate some help on this one, way out of my comfort zone!

O.K so based on the array type, temperature, FEQ hours and ground conductivity, i need to match the result to the table data. If there is no exact match I would need the next lowest data as opposed to higher.

Ideally I would like to be able to formulate the result by some clever maths using the data from the above and below and dividing it by the difference, but I think that may be asking to much???!!!

However, I would greatly appreciate anyones help overcoming this formula.

Thanks in advance!

Sam

[azumi]

Can you post with example results? Tell me the logic............

[nostrum]

Hi,

There should be an example on the right of the tables?

Let me know if you need anything else.

Appreciate the reply

[nostrum]

Hi,

Could anybody help with this at all?

Thanks in advance

[jhren]

Perhaps this will get things started.

Uses a dynamic named range ("lookup") which focuses on sub-table based on array type and fleq hours, then a vlookup formula in result cell matches ground conductivity and offsets to temperature.