Tip Printed from ExcelTip.com

---

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)