» Retrieving from List by Position
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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)
Book Store:
No comments have been submitted.
