» 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:
- East of Eden (Oprah's Book Club)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Finance and Accounting for Nonfinancial Managers
- Microsoft Windows XP Step by Step (With CD-ROM)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
