Excel formula - Index or?

[vijaychennai]

Hello all,

I have excel file in the below format.

Excel Workbook
	J
1	Rank
2	10
3	10.5
4	30
5	72
6	90
Sheet1

Answer :

Excel Workbook
	J	K
1	Rank	Split
2	10	8-10 Rank
3	10.5	10-12 Rank
4	30	28-30 Rank
5	72	70-72 Rank
6	90	> 72 Rank
Sheet1

Split :

Excel Workbook
	E	F	G
1	Start		Between
2	0	2	0-2 Rank
3	2	4	2-4 Rank
4	4	6	4-6 Rank
5	6	8	6-8 Rank
6	8	10	8-10 Rank
7	10	12	10-12 Rank
8	12	14	12-14 Rank
9	14	16	14-16 Rank
10	16	18	16-18 Rank
11	18	20	18-20 Rank
12	20	22	20-22 Rank
13	22	24	22-24 Rank
14	24	26	24-26 Rank
15	26	28	26-28 Rank
16	28	30	28-30 Rank
17	30	32	30-32 Rank
18	32	34	32-34 Rank
19	34	36	34-36 Rank
20	36	38	36-38 Rank
21	38	40	38-40 Rank
22	40	42	40-42 Rank
23	42	44	42-44 Rank
24	44	46	44-46 Rank
25	46	48	46-48 Rank
26	48	50	48-50 Rank
27	50	52	50-52 Rank
28	52	54	52-54 Rank
29	54	56	54-56 Rank
30	56	58	56-58 Rank
31	58	60	58-60 Rank
32	60	62	60-62 Rank
33	62	64	62-64 Rank
34	64	66	64-66 Rank
35	66	68	66-68 Rank
36	68	70	68-70 Rank
37	70	72	70-72 Rank
38	72	1000000	> 72 Rank
Sheet1

 

[Sixthsense]

May be this..

In K2 cell

=IFERROR(VLOOKUP($J2,$F$2:$G$38,2,TRUE),"")

Drag it down..

 

[vijaychennai]

Sorry Not working.

 

[Dave Patton]

Did you try the suggestions in your previous thread?

What Lookup formula did you try and what does "not working" mean?

N.B. You must provide the appropriate information for the Lookup Formula.