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

Numbers	Buckets
101	>100
100	76-100
75	51-75
50	0-50

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

 

[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