extracting data from a matrix/table with specific index
- October 19, 2010
- 2 replies
- 4881 views
This sheet represent calculation of hydrogen flow from through the porous membrane as a
function of time. The flow is experimentaly measured ("measuredFlow") and calculated from current (CurrentData), in order to compare yield. Notes reperesent temperature at certain time.
I want to correlate flow at the certain temperature, at a certain time.
This is performed by "CoolingIndex". The data in CoolingIndex table are acctually indexes
of the "absFlow", which is the flow at the certain time, at a certain temperature. And I want to extract only absFlow data with the index k.
The values in the CoolingIndex table are as they should be, when i perform this in Excell (manually). But somehow, the values of k are not the same as values in the CoolingIndex table. Where I am making a mistake? How can I obtain k, the same as the values in the CoolingIndex table.
Thanks!

