Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup using variable path name for range value
I have followed the examples here, but I still can't get excel to do what I
want, and I believe I'm having a syntax issue. In my workbook, I'm trying to refer to a workbook located on a netwrok drive: The network path and file name is: P:\My Documents\Alpha_Numeric.xls in cell A11 is the text: P:\My Documents\[Alpha_Numeric.xls]Sheet1 What I want to do is first a simple indirect using this string on a single cell. i.e. =INDIRECT("'"&A11&"'!$A:$2") This is not working. I am getting a #REF error. I am getting some same error trying to use indirect on a file on my desktop. cell a3 = C:\Documents and Settings\#jlowens\Desktop\[Alpha_Numeric.xls]Sheet1 =INDIRECT("'"&A3&"'!$a:$2") Can someone please explain what I am doing wrong. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup using variable path name for range value
Indirect needs the other workbook to be open. Laurent Longre has a utility
called Morefunc that has a function called INDIREC.EXT that will work and Harlan Grove wrote a UDF called Pull http://www.download.com/Morefunc/300...-10423160.html ftp://members.aol.com/hrlngrv/ (look for pull.zip) -- Regards, Peo Sjoblom Portland, Oregon "Jeff Lowenstein" wrote in message ... I have followed the examples here, but I still can't get excel to do what I want, and I believe I'm having a syntax issue. In my workbook, I'm trying to refer to a workbook located on a netwrok drive: The network path and file name is: P:\My Documents\Alpha_Numeric.xls in cell A11 is the text: P:\My Documents\[Alpha_Numeric.xls]Sheet1 What I want to do is first a simple indirect using this string on a single cell. i.e. =INDIRECT("'"&A11&"'!$A:$2") This is not working. I am getting a #REF error. I am getting some same error trying to use indirect on a file on my desktop. cell a3 = C:\Documents and Settings\#jlowens\Desktop\[Alpha_Numeric.xls]Sheet1 =INDIRECT("'"&A3&"'!$a:$2") Can someone please explain what I am doing wrong. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable col_index_num in vlookup | Excel Discussion (Misc queries) | |||
Creating cell references with variable values to use in Vlookup | Excel Discussion (Misc queries) | |||
Problems using a variable as a Table_Array in VLOOKUP | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions |