» Retrieving Values Using Range Names as References
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
First3 and Last3 are the defined Names for ranges A2:A4 and A5:A7 respectively.
We want to create a formula that will look up each of the values listed in column B for one of the names listed in column C.
Solution:
Use the VLOOKUP and INDIRECT functions as shown in the following formula:
=VLOOKUP(B2,INDIRECT(C2),1,FALSE),1,FALSE)
Book Store:
Recommended Books:
- Harry Potter and the Order of the Phoenix (Book 5)
- Microsoft Windows XP Step by Step (With CD-ROM)
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Windows XP Registry Guide
- Marketing Plans That Work, Targeting Growth and Profitability
- Business Analysis with Microsoft Excel (2nd Edition)
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
