Using Time as a lookup value - column A, then looking to return the header of the column that has value greater than specified trough concentration.
Example - at time = 7.00 hrs , concentration = 8.6, would like it to return q36h
Adapted this formula from another post
=(LOOKUP(B16,INDEX('ODA Gent Nomogram'!A3:E171,MATCH(B14,'ODA Gent Nomogram'!A3:A171,1),0),'ODA Gent Nomogram'!C2:E2))
Doesn't return correct value, in above example returns q48h
I think I'm close, but not sure where I'm off.
Thanks
Brant
Data Table
<tbody>
</tbody>
Example - at time = 7.00 hrs , concentration = 8.6, would like it to return q36h
Adapted this formula from another post
=(LOOKUP(B16,INDEX('ODA Gent Nomogram'!A3:E171,MATCH(B14,'ODA Gent Nomogram'!A3:A171,1),0),'ODA Gent Nomogram'!C2:E2))
Doesn't return correct value, in above example returns q48h
I think I'm close, but not sure where I'm off.
Thanks
Brant
Data Table
Time of Dose | Too Low | q24h | q36h | Q48h |
6.00 | 0.00 | 7.50 | 11.00 | 13.00 |
6.08 | 0.00 | 7.44 | 10.92 | 12.92 |
6.17 | 0.00 | 7.38 | 10.83 | 12.83 |
6.25 | 0.00 | 7.33 | 10.75 | 12.75 |
6.33 | 0.00 | 7.27 | 10.67 | 12.67 |
6.42 | 0.00 | 7.21 | 10.58 | 12.58 |
6.50 | 0.00 | 7.15 | 10.50 | 12.50 |
6.58 | 0.00 | 7.09 | 10.42 | 12.42 |
6.67 | 0.00 | 7.03 | 10.33 | 12.33 |
6.75 | 0.00 | 6.98 | 10.25 | 12.25 |
6.83 | 0.00 | 6.92 | 10.17 | 12.17 |
6.92 | 0.00 | 6.86 | 10.08 | 12.08 |
7.00 | 0.00 | 6.80 | 10.00 | 12.00 |
7.08 | 0.00 | 6.74 | 9.92 | 11.92 |
7.17 | 0.00 | 6.68 | 9.83 | 11.83 |
7.25 | 0.00 | 6.63 | 9.75 | 11.75 |
7.33 | 0.00 | 6.57 | 9.67 | 11.67 |
7.42 | 0.00 | 6.51 | 9.58 | 11.58 |
7.50 | 0.00 | 6.45 | 9.50 | 11.50 |
7.58 | 0.00 | 6.39 | 9.42 | 11.42 |
7.67 | 0.00 | 6.33 | 9.33 | 11.33 |
7.75 | 0.00 | 6.28 | 9.25 | 11.25 |
7.83 | 0.00 | 6.22 | 9.17 | 11.17 |
7.92 | 0.00 | 6.16 | 9.08 | 11.08 |
8.00 | 0.00 | 6.10 | 9.00 | 11.00 |
<tbody>
</tbody>