Excel formula for bucket/group

[kumar1803]

Hello,

I have some numbers in columns that I want to put them in bucket below. Please help create a formula based on below: Anything above 100 should show greater than 100, abything between 76-100 should show in 76-100 buckets, anything falls in between 51-75 should show in 51-75 bucket and number between 0-50 should show in 0-50 bucket

[TABLE="width: 214"]
<tbody>[TR]
[TD]Numbers[/TD]
[TD]Buckets[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]>100[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]76-100[/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD]51-75[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]0-50
[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[alansidman]

Reverse your look up table as shown below and use the Vlookup function as shown

Excel Workbook
	A	B	G	H
1	*	*	Numbers	Bucket
2	5	0-50	0	0-50
3	55	51-75	51	51-75
4	80	76-100	76	76-100
5	120	>100	101	>100
Sheet1