|
» Retrieving File Name by Matching a Given Page Number in a Book
CATEGORY: Lookup Formulas |
VERSIONS: All Microsoft Excel Versions |
|
Problem: 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)) |
|
RATING:
5.00
VIEWS: 7153 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Access 2002 for Dummies
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The 22 Immutable Laws of Branding
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Windows XP Pocket Reference
- Microsoft Office XP Introductory Concepts and Techniques
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
