» Retrieving Values from another Excel Workbook Using Text References
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Listed in column A are the path, file name, sheet name, and cell reference for a range containing pairs of numbers and letters.
We want to lookup each of the numbers in column C in the range specified in column A and retrieve the matching letters.
Solution:
To retrieve the values listed in column C in the range specified in column A, use the VLOOKUP and INDIRECT function as shown in the following formula:
=VLOOKUP(C2,INDIRECT("'"&$A$2&"\["&$A$5&".xls]"&$A$8&"'!"&$A$11),2,FALSE)
Book Store:
Recommended Books:
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Investing in Real Estate, Fourth Edition
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Fall of Advertising and the Rise of PR
Alvin Linardi
Can you give a example in excel worksheet for this tip.
Retrieving Values from another Excel Workbook Using Text References
http://www.exceltip.com/st/Retrieving_Values_from_another_Excel_Workbook_Using_Text_References/981.html
Thanks,Alvin
linardi@centrin.net.id
how to do this when the other workbook is closed
vkohli
how can I do the above when the other workbook to which I am referencing is closed. In this case, the indirect function will throw up an error. I am simply trying to link a cell in a wkbook with another.
Am using this formula,
A1=INDIRECT("'[FirstName "&RIGHT(myname(),10)&"]"&"Master"&"'!"&"A1")
myname is a function that I have defined which throws up the value of the workbook in which you are working.
It gives FirstName Apr 07.xls
right(myname(),10) then can be used to refer to different months depending on the wkbook.
Please help.
Week Number to Date
tmarzean
I need to change a a Week number to a date.
1 will equal 1/06/07
2 will equal 1/13/07
3 will equal 1/20/07
how can I retrieve cell value from database to my excel workbook?
thank you
nono_san2004@yahoo.com.au