#### cutch22

##### New Member
 I'm a nurse in an MBA computer course, I do not use excel ever. I'm doing a final project and want to make it relevant to healthcare. I want to have a formula in the "action" column below that will return the "result" based on the "sliding scale" and the "patient's glucos." I was thinking vlookup or index with no luck. Thanks in advance you excel savants!! For example in the first row, the glucose level of 123 should return "No action" in the action column Insulin Sliding Scale Protocol Slide Scale Result Patient Glucose Action <50 50mL IV Dextrose 123 51-79 15g oral glucose 234 80-149 No action 457 150-189 1 Unit Humalog 43 190-249 2 Unit Humalog 68 250-299 3 Unit Humalog 176 300-349 4 Unit Humalog 363 350-399 5 Unit Humalog 311 >400 Call MD 282

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Welcome to MrExcel.

You'll need to change the first column of your table:

Excel 2010
ABCD
1Insulin Sliding Scale Protocol
2Slide ScaleResultPatient GlucoseAction
3050mL IV Dextrose123No action
45115g oral glucose2342 Unit Humalog
580No action457Call MD
61501 Unit Humalog4350mL IV Dextrose
71902 Unit Humalog6815g oral glucose
82503 Unit Humalog1761 Unit Humalog
93004 Unit Humalog3635 Unit Humalog
103505 Unit Humalog3114 Unit Humalog
11400Call MD2823 Unit Humalog

</tbody>
Sheet3

Worksheet Formulas
CellFormula
D3=VLOOKUP(C3,\$A\$3:\$B\$11,2)

</tbody>

<tbody>
</tbody>

Wow thanks so much!! You guys should start charging for this help, I'm not joking.

Replies
3
Views
1K

1,206,761
Messages
6,074,786
Members
446,088
Latest member
Koustubh12

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back