# MATCH and OFFSET.. , or INDEX

#### HusseinGillani

##### New Member

Countries Resort Income Rank

Haiti \$....... 4
Aruba .... 1
Cuba 2
Puerto Rico 3

Country
1.
2.
3.
4

My spreadsheet is much larger and the columns are not right next to each other. I was wonder how I could display country names resorted by rank using either MATCH and OFFSET or INDEX. This is for a basic excel class, so simpler solution would be appreciated.

Thanks so much

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### CWatts

##### Well-known Member
I would use index and match;

 * A B 1 Haiti 4 2 Aruba 1 3 Cuba 2 4 Puerto Rico 3 5 6 Rank Country 7 1 Aruba 8 2 Cuba 9 3 Puerto Rico 10 4 Haiti

<tbody>
</tbody>

 Cell Formula B7 =INDEX(\$A\$1:\$A\$4,MATCH(A7,\$B\$1:\$B\$4,0)) B8 =INDEX(\$A\$1:\$A\$4,MATCH(A8,\$B\$1:\$B\$4,0)) B9 =INDEX(\$A\$1:\$A\$4,MATCH(A9,\$B\$1:\$B\$4,0)) B10 =INDEX(\$A\$1:\$A\$4,MATCH(A10,\$B\$1:\$B\$4,0))

<tbody>
</tbody>

<tbody>
</tbody>

Excel tables to the web >>

Thanks so much!

Replies
5
Views
410
Replies
3
Views
592
Replies
3
Views
129
Replies
3
Views
1K
Replies
5
Views
290

1,195,663
Messages
6,011,009
Members
441,579
Latest member
satishrazdhan

### 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.

### Which adblocker are you using?

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

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