Interpolation/vlookup question.
 

Basically i got 4 tables.
table 1: temperature for different elevation for part 1 and 2.
table 2: concentration for different elevation for part 1 and 2.
table 4: Cumulative population for different elevation for part 1 and
2.

Table 3 are what I want to calculate. I want to get the elevation
range(low limit and high limit) which satisfy two criteria:
temperature <10 and concentration 5 from table 1 and 2. And then
calculate the population in these range using table 4.

Anyone can help?

Thanks a lot.

stone.





1 Temperature
Elevation Part 1 Part 2
1355.5 10.42 10.87
1354.5 10.06 10.39
1353.5 9.78 9.98
1352.5 9.62 9.7
1351.5 9.57 9.5
1350.5 9.52 9.43

2 Concentration
Elevation Part 1 Part 2
1355.50 7.50 8.20
1354.50 7.00 8.00
1353.50 6.50 7.70
1352.50 6.00 7.30
1351.50 5.50 6.80
1350.50 4.20 5.20

3
Elevation Part 1 Part 2
Low limit
High limit
population


4 Cumulative population
Elevation Part 1 Part 2
1356.3 1,921 16,772
1355 886 9,491
1354.5 355 4,158
1353.2 76 1,246
1352.6 0 289
1351.8 0 118
1349.3 0 26