Excel formula - Index or?

vijaychennai

Board Regular
Joined
Dec 7, 2009
Messages
239
Hello all,

I have excel file in the below format.

Excel Workbook
J
1Rank
210
310.5
430
572
690
Sheet1



Answer :

Excel Workbook
JK
1RankSplit
2108-10 Rank
310.510-12 Rank
43028-30 Rank
57270-72 Rank
690> 72 Rank
Sheet1



Split :

Excel Workbook
EFG
1StartBetween
2020-2 Rank
3242-4 Rank
4464-6 Rank
5686-8 Rank
68108-10 Rank
7101210-12 Rank
8121412-14 Rank
9141614-16 Rank
10161816-18 Rank
11182018-20 Rank
12202220-22 Rank
13222422-24 Rank
14242624-26 Rank
15262826-28 Rank
16283028-30 Rank
17303230-32 Rank
18323432-34 Rank
19343634-36 Rank
20363836-38 Rank
21384038-40 Rank
22404240-42 Rank
23424442-44 Rank
24444644-46 Rank
25464846-48 Rank
26485048-50 Rank
27505250-52 Rank
28525452-54 Rank
29545654-56 Rank
30565856-58 Rank
31586058-60 Rank
32606260-62 Rank
33626462-64 Rank
34646664-66 Rank
35666866-68 Rank
36687068-70 Rank
37707270-72 Rank
38721000000> 72 Rank
Sheet1
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Sixthsense

Active Member
Joined
Nov 19, 2012
Messages
385
May be this..

In K2 cell

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

Drag it down..
 

Dave Patton

Well-known Member
Joined
Feb 15, 2002
Messages
4,572
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,123,156
Messages
5,600,033
Members
414,356
Latest member
death20

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top