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

[cutch22]

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>

 

[Andrew Poulsom]

Welcome to MrExcel.

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

Excel 2010

	A	B	C	D
1	Insulin Sliding Scale Protocol
2	Slide Scale	Result	Patient Glucose	Action
3	0	50mL IV Dextrose	123	No action
4	51	15g oral glucose	234	2 Unit Humalog
5	80	No action	457	Call MD
6	150	1 Unit Humalog	43	50mL IV Dextrose
7	190	2 Unit Humalog	68	15g oral glucose
8	250	3 Unit Humalog	176	1 Unit Humalog
9	300	4 Unit Humalog	363	5 Unit Humalog
10	350	5 Unit Humalog	311	4 Unit Humalog
11	400	Call MD	282	3 Unit Humalog

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

Sheet3​

Worksheet Formulas Cell Formula D3 =VLOOKUP(C3,$A$3:$B$11,2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[cutch22]

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