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
[TABLE="width: 258"]
<tbody>[TR]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Time of Dose
[/TD]
[TD="bgcolor: transparent"]Too Low
[/TD]
[TD="bgcolor: transparent"]q24h
[/TD]
[TD="bgcolor: transparent"]q36h
[/TD]
[TD="bgcolor: transparent"]Q48h
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.50
[/TD]
[TD="bgcolor: transparent, align: right"]11.00
[/TD]
[TD="bgcolor: transparent, align: right"]13.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.08
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.44
[/TD]
[TD="bgcolor: transparent, align: right"]10.92
[/TD]
[TD="bgcolor: transparent, align: right"]12.92
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.17
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.38
[/TD]
[TD="bgcolor: transparent, align: right"]10.83
[/TD]
[TD="bgcolor: transparent, align: right"]12.83
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.25
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.33
[/TD]
[TD="bgcolor: transparent, align: right"]10.75
[/TD]
[TD="bgcolor: transparent, align: right"]12.75
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.27
[/TD]
[TD="bgcolor: transparent, align: right"]10.67
[/TD]
[TD="bgcolor: transparent, align: right"]12.67
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.42
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.21
[/TD]
[TD="bgcolor: transparent, align: right"]10.58
[/TD]
[TD="bgcolor: transparent, align: right"]12.58
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.50
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.15
[/TD]
[TD="bgcolor: transparent, align: right"]10.50
[/TD]
[TD="bgcolor: transparent, align: right"]12.50
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.58
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.09
[/TD]
[TD="bgcolor: transparent, align: right"]10.42
[/TD]
[TD="bgcolor: transparent, align: right"]12.42
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.03
[/TD]
[TD="bgcolor: transparent, align: right"]10.33
[/TD]
[TD="bgcolor: transparent, align: right"]12.33
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.75
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.98
[/TD]
[TD="bgcolor: transparent, align: right"]10.25
[/TD]
[TD="bgcolor: transparent, align: right"]12.25
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.83
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.92
[/TD]
[TD="bgcolor: transparent, align: right"]10.17
[/TD]
[TD="bgcolor: transparent, align: right"]12.17
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.92
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.86
[/TD]
[TD="bgcolor: transparent, align: right"]10.08
[/TD]
[TD="bgcolor: transparent, align: right"]12.08
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.80
[/TD]
[TD="bgcolor: transparent, align: right"]10.00
[/TD]
[TD="bgcolor: transparent, align: right"]12.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.08
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.74
[/TD]
[TD="bgcolor: transparent, align: right"]9.92
[/TD]
[TD="bgcolor: transparent, align: right"]11.92
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.17
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.68
[/TD]
[TD="bgcolor: transparent, align: right"]9.83
[/TD]
[TD="bgcolor: transparent, align: right"]11.83
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.25
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.63
[/TD]
[TD="bgcolor: transparent, align: right"]9.75
[/TD]
[TD="bgcolor: transparent, align: right"]11.75
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.57
[/TD]
[TD="bgcolor: transparent, align: right"]9.67
[/TD]
[TD="bgcolor: transparent, align: right"]11.67
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.42
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.51
[/TD]
[TD="bgcolor: transparent, align: right"]9.58
[/TD]
[TD="bgcolor: transparent, align: right"]11.58
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.50
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.45
[/TD]
[TD="bgcolor: transparent, align: right"]9.50
[/TD]
[TD="bgcolor: transparent, align: right"]11.50
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.58
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.39
[/TD]
[TD="bgcolor: transparent, align: right"]9.42
[/TD]
[TD="bgcolor: transparent, align: right"]11.42
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.33
[/TD]
[TD="bgcolor: transparent, align: right"]9.33
[/TD]
[TD="bgcolor: transparent, align: right"]11.33
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.75
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.28
[/TD]
[TD="bgcolor: transparent, align: right"]9.25
[/TD]
[TD="bgcolor: transparent, align: right"]11.25
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.83
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.22
[/TD]
[TD="bgcolor: transparent, align: right"]9.17
[/TD]
[TD="bgcolor: transparent, align: right"]11.17
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.92
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.16
[/TD]
[TD="bgcolor: transparent, align: right"]9.08
[/TD]
[TD="bgcolor: transparent, align: right"]11.08
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.10
[/TD]
[TD="bgcolor: transparent, align: right"]9.00
[/TD]
[TD="bgcolor: transparent, align: right"]11.00
[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 258"]
<tbody>[TR]
[TD="width: 88, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Time of Dose
[/TD]
[TD="bgcolor: transparent"]Too Low
[/TD]
[TD="bgcolor: transparent"]q24h
[/TD]
[TD="bgcolor: transparent"]q36h
[/TD]
[TD="bgcolor: transparent"]Q48h
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.50
[/TD]
[TD="bgcolor: transparent, align: right"]11.00
[/TD]
[TD="bgcolor: transparent, align: right"]13.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.08
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.44
[/TD]
[TD="bgcolor: transparent, align: right"]10.92
[/TD]
[TD="bgcolor: transparent, align: right"]12.92
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.17
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.38
[/TD]
[TD="bgcolor: transparent, align: right"]10.83
[/TD]
[TD="bgcolor: transparent, align: right"]12.83
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.25
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.33
[/TD]
[TD="bgcolor: transparent, align: right"]10.75
[/TD]
[TD="bgcolor: transparent, align: right"]12.75
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.27
[/TD]
[TD="bgcolor: transparent, align: right"]10.67
[/TD]
[TD="bgcolor: transparent, align: right"]12.67
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.42
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.21
[/TD]
[TD="bgcolor: transparent, align: right"]10.58
[/TD]
[TD="bgcolor: transparent, align: right"]12.58
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.50
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.15
[/TD]
[TD="bgcolor: transparent, align: right"]10.50
[/TD]
[TD="bgcolor: transparent, align: right"]12.50
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.58
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.09
[/TD]
[TD="bgcolor: transparent, align: right"]10.42
[/TD]
[TD="bgcolor: transparent, align: right"]12.42
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]7.03
[/TD]
[TD="bgcolor: transparent, align: right"]10.33
[/TD]
[TD="bgcolor: transparent, align: right"]12.33
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.75
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.98
[/TD]
[TD="bgcolor: transparent, align: right"]10.25
[/TD]
[TD="bgcolor: transparent, align: right"]12.25
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.83
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.92
[/TD]
[TD="bgcolor: transparent, align: right"]10.17
[/TD]
[TD="bgcolor: transparent, align: right"]12.17
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6.92
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.86
[/TD]
[TD="bgcolor: transparent, align: right"]10.08
[/TD]
[TD="bgcolor: transparent, align: right"]12.08
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.80
[/TD]
[TD="bgcolor: transparent, align: right"]10.00
[/TD]
[TD="bgcolor: transparent, align: right"]12.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.08
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.74
[/TD]
[TD="bgcolor: transparent, align: right"]9.92
[/TD]
[TD="bgcolor: transparent, align: right"]11.92
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.17
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.68
[/TD]
[TD="bgcolor: transparent, align: right"]9.83
[/TD]
[TD="bgcolor: transparent, align: right"]11.83
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.25
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.63
[/TD]
[TD="bgcolor: transparent, align: right"]9.75
[/TD]
[TD="bgcolor: transparent, align: right"]11.75
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.33
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.57
[/TD]
[TD="bgcolor: transparent, align: right"]9.67
[/TD]
[TD="bgcolor: transparent, align: right"]11.67
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.42
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.51
[/TD]
[TD="bgcolor: transparent, align: right"]9.58
[/TD]
[TD="bgcolor: transparent, align: right"]11.58
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.50
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.45
[/TD]
[TD="bgcolor: transparent, align: right"]9.50
[/TD]
[TD="bgcolor: transparent, align: right"]11.50
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.58
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.39
[/TD]
[TD="bgcolor: transparent, align: right"]9.42
[/TD]
[TD="bgcolor: transparent, align: right"]11.42
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.67
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.33
[/TD]
[TD="bgcolor: transparent, align: right"]9.33
[/TD]
[TD="bgcolor: transparent, align: right"]11.33
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.75
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.28
[/TD]
[TD="bgcolor: transparent, align: right"]9.25
[/TD]
[TD="bgcolor: transparent, align: right"]11.25
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.83
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.22
[/TD]
[TD="bgcolor: transparent, align: right"]9.17
[/TD]
[TD="bgcolor: transparent, align: right"]11.17
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7.92
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.16
[/TD]
[TD="bgcolor: transparent, align: right"]9.08
[/TD]
[TD="bgcolor: transparent, align: right"]11.08
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8.00
[/TD]
[TD="bgcolor: transparent, align: right"]0.00
[/TD]
[TD="bgcolor: transparent, align: right"]6.10
[/TD]
[TD="bgcolor: transparent, align: right"]9.00
[/TD]
[TD="bgcolor: transparent, align: right"]11.00
[/TD]
[/TR]
</tbody>[/TABLE]