» 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:
- The One Page Business Plan: Start With a Vision, Build a Company!
- Monte Carlo Methods in Finance
- Special Edition Using Microsoft Access 2002
- Microsoft Excel Version 2002 Step by Step
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- The 11 Immutable Laws of Internet Branding
[url]http://www.exceltip.com/st/Looking_Up_A_Value_In_A_Name_Range/878.html[/url]
Which shows a wrong formula
=VLOOKUP(B2,INDIRECT(C2),1,FALSE),1,FALSE)
compared to the formula in this topic
=VLOOKUP(B2,INDIRECT(C2),1,FALSE)
Also, it shows column A but doesn't show what's in columns B and C.