One cell populates with a # when an adjacent cell falls between two numbers

[whattruck]

Hello. This is my first post on the forum. I am attempting to create a formula where a cell will populate with a certain number when an adjacent cell is between two numbers. In plain language B2 will fill with "1" when C2's data falls between 0 and 14. I have four additional number ranges: B2 will fill with "2" when C2's data falls between 15 and 31; B2 will fill with "3L" when C2's data falls between 32 and 45; B2 will fill with "3H" when C2's data falls between 46 and 60; B2 will fill with "4" when C2's data falls between 61 and 67; B2 will fill with "5" when C2's data falls between 68 and 90.

The number ranges are weather data that dictate staffing levels (B2).

Here is a screenshot:

https://drive.google.com/drive/u/1/folders/0Bx98SOpH4kJKVUpnS2g5cUU4MHM

Weather data ranges are on bottom right.

Please let me know if I can flesh out my question anymore.

Thank you for your assistance.

William

 

[wideboydixon]

Book1
	B	C
2	1	1
3	2	15
4	3L	37
5	3H	46
6	4	67
7	5	85
Sheet3

Cell Formulas
Range	Formula
B2	=VLOOKUP($C2,{0,"1";15,"2";32,"3L";46,"3H";61,"4";68,"5"},2,TRUE)

WBD

 

[whattruck]

WBD,
This worked brilliantly. Thank you for your very quick response. It was a lifesaver and game changer!

W