Please help with the correct formula to fill in the chart below

[cutch22]

[TABLE="width: 464"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]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[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Slide Scale[/TD]
[TD]Result[/TD]
[TD]Patient Glucose[/TD]
[TD]Action[/TD]
[/TR]
[TR]
[TD]<50[/TD]
[TD]50mL IV Dextrose[/TD]
[TD="align: right"]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]51-79[/TD]
[TD]15g oral glucose[/TD]
[TD="align: right"]234[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]80-149[/TD]
[TD]No action[/TD]
[TD="align: right"]457[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]150-189[/TD]
[TD]1 Unit Humalog[/TD]
[TD="align: right"]43[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]190-249[/TD]
[TD]2 Unit Humalog[/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]250-299[/TD]
[TD]3 Unit Humalog[/TD]
[TD="align: right"]176[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300-349[/TD]
[TD]4 Unit Humalog[/TD]
[TD="align: right"]363[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]350-399[/TD]
[TD]5 Unit Humalog[/TD]
[TD="align: right"]311[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]>400[/TD]
[TD]Call MD[/TD]
[TD="align: right"]282[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Welcome to MrExcel.

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

Excel 2010

	A	B	C	D
Insulin Sliding Scale Protocol
Slide Scale	Result	Patient Glucose	Action
50mL IV Dextrose	No action
15g oral glucose	2 Unit Humalog
No action	Call MD
1 Unit Humalog	50mL IV Dextrose
2 Unit Humalog	15g oral glucose
3 Unit Humalog	1 Unit Humalog
4 Unit Humalog	5 Unit Humalog
5 Unit Humalog	4 Unit Humalog
Call MD	3 Unit Humalog

<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]0[/TD]

[TD="align: right"]123[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]51[/TD]

[TD="align: right"]234[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]80[/TD]

[TD="align: right"]457[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]150[/TD]

[TD="align: right"]43[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]190[/TD]

[TD="align: right"]68[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]250[/TD]

[TD="align: right"]176[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]300[/TD]

[TD="align: right"]363[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]350[/TD]

[TD="align: right"]311[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]400[/TD]

[TD="align: right"]282[/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: #DAE7F5"]D3[/TH]
[TD="align: left"]=VLOOKUP(C3,$A$3:$B$11,2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[cutch22]

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