Can I search for a number in a range?

If you post a workbook with some sample data it will be much easier to help you.

Try this...

Data Range

	A	B	C	D	E
1	------	------	------	------	------
2	56	50 - 59		0	0 - 9
3				10	10 - 19
4				20	20 - 29
5				30	30 - 39
6				40	40 - 49
7				50	50 - 59
8				60	60 - 69
9				70	70 - 79
10				80	80 - 89
11				90	90 - 99
12				100	100 - 109

This formula entered in B2:

=LOOKUP(A2,D2:E12)

You could try something like this... =LOOKUP(A2,{0,21,31,41,51,61,71,81,91},{"0-20","21-30","31-40","41-50","51-60","61-70","71-80","81-90","90+"})

If you have your data in B1 try below formula in C1 and copy towards down
=IFERROR(LOOKUP(B1,{1,10,20,30,40,50,60,70,80,90,100},{"0-9","10-19","20-29","30-39","40-49","50-59","60-69","70-79","80-89","90-99","100 & above"}),"")

Please Login or Register  to view this content.

Like this...

Data Range

	A	B	C	D	E	F
1	ID	Age	Age Range		Age	Range
2	1	30	30 - 39		0	0 - 9
3	2	26	20 - 29		10	10 - 19
4	3	24	20 - 29		20	20 - 29
5	4	27	20 - 29		30	30 - 39
6	5	25	20 - 29		40	40 - 49
7	6	32	30 - 39		50	50 - 59
8	7	50	50 - 59		60	60 - 69
9	8	38	30 - 39		70	70 - 79
10	9	41	40 - 49		80	80 - 89
11	10	20	20 - 29		90	90 - 99
12	11	49	40 - 49		100	100 - 109
13	12	19	10 - 19
14	13	45	40 - 49
15	14	28	20 - 29
16	15	22	20 - 29
17	16	24	20 - 29
18	17	48	40 - 49
19	18	19	10 - 19
20	19	29	20 - 29
21	20	19	10 - 19
22	------	------	------	------	------	------

This formula entered in C2 and copied down:

=LOOKUP(B2,E$2:F$12)