Mokhsein Abbdullah
New Member
We have created an Excel file with several sheets to perform electric power correction calculations for data collected during power plant testing. One particular sheet comprises a table extracted from an ISO Standard, i.e ISO3046-1, which shows standard water vapour pressure at various atmospheric temperatures versus relative humidity. In the same sheet I have set up a small table to perform extrapolation calculations using actual data captured during the power plant testing.
I have attached the Excel file showing the sheet concerned. In the smaller "Extrapolation Calculation" table all the non-highlighted cells are already handled by links to other sheets or by formulae which I have set. I am only looking to set the right formulae in the cells highlighted in yellow to extract the right values from the Table B.1. At present the cells highlighted in yellow are being entered manually by reference to the Table B.1. For example the intersection of 32 and 0.5 is read from the Table B.1 as 2.36, and similarly the intersection of 34 and 0.4 is read from the Table B.1 as 2.12.
I have tried INDEX & MATCH, SUMPRODUCT and VLOOKUP with MATCH but have failed to set the right formulae. Any help on this would be very much appreciated.
I have attached the Excel file showing the sheet concerned. In the smaller "Extrapolation Calculation" table all the non-highlighted cells are already handled by links to other sheets or by formulae which I have set. I am only looking to set the right formulae in the cells highlighted in yellow to extract the right values from the Table B.1. At present the cells highlighted in yellow are being entered manually by reference to the Table B.1. For example the intersection of 32 and 0.5 is read from the Table B.1 as 2.36, and similarly the intersection of 34 and 0.4 is read from the Table B.1 as 2.12.
I have tried INDEX & MATCH, SUMPRODUCT and VLOOKUP with MATCH but have failed to set the right formulae. Any help on this would be very much appreciated.