Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup reference a worksheet
I am attempting to use Vlookup to do a multiple lookup.
I have 7 different worksheets and would like the worksheet names to be one variable and the worksheet to be a second variable, the vlookup formula is below. $f$3 is a list of months. I would like to find a way to set the 'a26' to be a variable, so that I can look in different worksheets- depending on what is input. Each worksheet is an individual person that I need to look up data on. =VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,) |
#2
|
|||
|
|||
Perfect. Thanks so much.
"Duke Carey" wrote: This should do the trick - if you other workbooks are all open =VLOOKUP($F$3,INDIRECT("'"&a26&"'!$A$2:$J$3639"),2 ,) "Mark Brown" wrote: I am attempting to use Vlookup to do a multiple lookup. I have 7 different worksheets and would like the worksheet names to be one variable and the worksheet to be a second variable, the vlookup formula is below. $f$3 is a list of months. I would like to find a way to set the 'a26' to be a variable, so that I can look in different worksheets- depending on what is input. Each worksheet is an individual person that I need to look up data on. =VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,) |
#3
|
|||
|
|||
That formula is great and should work just fine. There is one thing to note
however. Vlookup is a relatively slow function to execute and indirect is a volitile function (calculates every time a calculation runs). Using the two together means that the vlookup must recalculate every time and if you create a whole bunch of these your performance will be adversly effected. I am not saying don't do it. Just be aware of the possible performance issues. -- HTH... Jim Thomlinson "Duke Carey" wrote: This should do the trick - if you other workbooks are all open =VLOOKUP($F$3,INDIRECT("'"&a26&"'!$A$2:$J$3639"),2 ,) "Mark Brown" wrote: I am attempting to use Vlookup to do a multiple lookup. I have 7 different worksheets and would like the worksheet names to be one variable and the worksheet to be a second variable, the vlookup formula is below. $f$3 is a list of months. I would like to find a way to set the 'a26' to be a variable, so that I can look in different worksheets- depending on what is input. Each worksheet is an individual person that I need to look up data on. =VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup reference a worksheet
What is the syntax of the path name?
For instance, what would be the syntax for the file Text.xls located on the desktop of user jeff ( windows 2000 or xp system)? What would be there besides: C:\DOCUMENTS AND SETTINGS\JEFF\DESKTOP\[TEST.XLS] "Jim Thomlinson" wrote: That formula is great and should work just fine. There is one thing to note however. Vlookup is a relatively slow function to execute and indirect is a volitile function (calculates every time a calculation runs). Using the two together means that the vlookup must recalculate every time and if you create a whole bunch of these your performance will be adversly effected. I am not saying don't do it. Just be aware of the possible performance issues. -- HTH... Jim Thomlinson "Duke Carey" wrote: This should do the trick - if you other workbooks are all open =VLOOKUP($F$3,INDIRECT("'"&a26&"'!$A$2:$J$3639"),2 ,) "Mark Brown" wrote: I am attempting to use Vlookup to do a multiple lookup. I have 7 different worksheets and would like the worksheet names to be one variable and the worksheet to be a second variable, the vlookup formula is below. $f$3 is a list of months. I would like to find a way to set the 'a26' to be a variable, so that I can look in different worksheets- depending on what is input. Each worksheet is an individual person that I need to look up data on. =VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup reference a worksheet
C:\Documents and Settings\Jeff\Desktop\[Test.xls]
so you have the correct path but unless the Test workbook is open you cannot use INDIRECT Btw, if you open Test.xls, copy a cell and paste special as link into another workbook, if you close Text you'll get the full path, also =CELL(Filename",A1) will return path plus sheet name -- Regards, Peo Sjoblom Portland, Oregon "Jeff Lowenstein" wrote in message ... What is the syntax of the path name? For instance, what would be the syntax for the file Text.xls located on the desktop of user jeff ( windows 2000 or xp system)? What would be there besides: C:\DOCUMENTS AND SETTINGS\JEFF\DESKTOP\[TEST.XLS] "Jim Thomlinson" wrote: That formula is great and should work just fine. There is one thing to note however. Vlookup is a relatively slow function to execute and indirect is a volitile function (calculates every time a calculation runs). Using the two together means that the vlookup must recalculate every time and if you create a whole bunch of these your performance will be adversly effected. I am not saying don't do it. Just be aware of the possible performance issues. -- HTH... Jim Thomlinson "Duke Carey" wrote: This should do the trick - if you other workbooks are all open =VLOOKUP($F$3,INDIRECT("'"&a26&"'!$A$2:$J$3639"),2 ,) "Mark Brown" wrote: I am attempting to use Vlookup to do a multiple lookup. I have 7 different worksheets and would like the worksheet names to be one variable and the worksheet to be a second variable, the vlookup formula is below. $f$3 is a list of months. I would like to find a way to set the 'a26' to be a variable, so that I can look in different worksheets- depending on what is input. Each worksheet is an individual person that I need to look up data on. =VLOOKUP($F$3,'a26'!$A$2:$J$3639,2,) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup reference a worksheet | Excel Worksheet Functions | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |