IF formula not robust enough

[RMAllen18]

Hello,
I am trying to calculate headcount needed based off of volume. There is a toggle used in the calculation that I can say I need per 100 units of volume, per 200, etc. but I only went up to the toggle value times 4. I need the formula to possibly support a much larger volume such as 40 times the toggle number. Below is the current formula I am using. Can anyone help with a better formula to use in this scenario please?
=IF(D2>=$F$2*4,4,IF(D2>=$F$2*3,3, IF(D2>=$F$2*2,2,IF(D2>=$F$2*1,1,0))))

Column A	Column B	Column C	Column D	Column E	Column F
Row 1	Month 1	Month 2	Month 3	Month 4	Toggle
Row 2		100	700	1,300	200
Row 3 (RESULT)			3	6

<tbody>
</tbody>

 

[Andrew Poulsom]

Welcome to MrExcel.

Use a lookup table:

http://www.contextures.com/xlFunctions02.html

 

[RMAllen18]

Thanks Andrew! I don't really want another tab or hidden columns though. I was hoping to keep it simple as the finished spreadsheet already has multiple tabs which all feed into a Detailed Income Statement. Do you know any formula I can utilize with what I am calling the Toggle field?