» Retrieving File Name by Matching a Given Page Number in a Book
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
The typed manuscript of a book was divided into five files.
Columns B & C contain the numbers of the first and last page included in each of the files.
We want to retrieve the file name corresponding to each page number listed in column E.
Solution:
Use the INDEX and MATCH functions as shown in the following formula:
=INDEX($A$2:$A$6,MATCH(E2,$B$2:$B$6))
Book Store:
Recommended Books:
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Outlook 2002 for Dummies
- Advanced modelling in finance using Excel and VBA
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Investing in Real Estate, Fourth Edition
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
No comments have been submitted.
