Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference previous worksheet within VLOOKUP
I have found several previous postings about this, but still cannot get my
function to work. If I put the name of the previous worksheet (e.g. March 09! {formatted as text}) in a cell (T2), then in my VLOOKUP I use VLOOKUP(A2, INDIRECT($T$2&A2:B100,1),FALSE) I get either #REF or #VALUE error, depending on how I tinker with the formula. Not sure what is missing. Using EXCEL 2000. Any assistance would be appreciated. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference previous worksheet within VLOOKUP
On Fri, 17 Apr 2009 10:54:11 -0700, Alex Mackenzie
wrote: I have found several previous postings about this, but still cannot get my function to work. If I put the name of the previous worksheet (e.g. March 09! {formatted as text}) in a cell (T2), then in my VLOOKUP I use VLOOKUP(A2, INDIRECT($T$2&A2:B100,1),FALSE) I get either #REF or #VALUE error, depending on how I tinker with the formula. Not sure what is missing. Using EXCEL 2000. Any assistance would be appreciated. Thank you. Try this formula: =VLOOKUP(A2,INDIRECT($T$2&"A2:B100"),1,FALSE) or =VLOOKUP(A2,INDIRECT($T$2&"A2:B100"),2,FALSE) if you want values from the B column to be returned. Note the " around A2:B100 and that the 1 (or the 2) is outside the call to INDIRECT rather than inside as in your formula. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference previous worksheet within VLOOKUP
=VLOOKUP(A2,INDIRECT("'"&T2&"'!A2:B100"),2,0)
"Alex Mackenzie" wrote: I have found several previous postings about this, but still cannot get my function to work. If I put the name of the previous worksheet (e.g. March 09! {formatted as text}) in a cell (T2), then in my VLOOKUP I use VLOOKUP(A2, INDIRECT($T$2&A2:B100,1),FALSE) I get either #REF or #VALUE error, depending on how I tinker with the formula. Not sure what is missing. Using EXCEL 2000. Any assistance would be appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I reference a cell on a previous worksheet | Excel Discussion (Misc queries) | |||
formula to reference cell on previous worksheet | Excel Worksheet Functions | |||
Reference Previous Worksheet Built-in Function | Excel Worksheet Functions | |||
need formula to reference a cell in previous worksheet | Excel Worksheet Functions | |||
How to reference to the previous worksheet regardless of title? | Excel Worksheet Functions |