» Retrieving From List By Position

Problem:

Sorting List1 (column A) according to position numbers as shown in column B.

Solution:

Use the INDEX function as shown in the following formula:
=INDEX($A$2:$A$6,B2)



Example:

List1_______Position______Result
Mike________5_____________Rachel
Ron_________4_____________Mischelle
David_______3_____________David
Mischelle___2_____________Ron
Rachel______1_____________Mike

Screenshot // Retrieving From List By Position