» 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:
- The One Page Business Plan: Start With a Vision, Build a Company!
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Access 2002 for Dummies
- Wall Street Journal Guide to Understanding Money and Investing
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Dictionary of Finance and Investment Terms
No comments have been submitted.

