» Retrieving from List by Position
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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:
Recommended Books:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Office XP Introductory Concepts and Techniques
- Keys to Reading an Annual Report (Barron's Business Keys)
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Special Edition Using Microsoft Office XP
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
