| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell VLookup
Hi All
I am trying to set the "table_array' part of this formula an individual cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38 =VLOOKUP(A8,'15.04.08'!A3:K38,7) Basically trying to define which worksheet to look in for the value. Hope this makes sense Cheers |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell VLookup
I'm assuming the lookup table is in the *same* range on the different
sheets. A7 = sheet name = 15.04.08 =VLOOKUP(A8,INDIRECT("'"&A7&"'!A3:K38"),7) -- Biff Microsoft Excel MVP "Rich" wrote in message ... Hi All I am trying to set the "table_array' part of this formula an individual cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38 =VLOOKUP(A8,'15.04.08'!A3:K38,7) Basically trying to define which worksheet to look in for the value. Hope this makes sense Cheers |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell VLookup
Hi Biff
just tried this with no joy, responds with a #Ref error, and yes the lookup is the same range on each sheet "T. Valko" wrote: I'm assuming the lookup table is in the *same* range on the different sheets. A7 = sheet name = 15.04.08 =VLOOKUP(A8,INDIRECT("'"&A7&"'!A3:K38"),7) -- Biff Microsoft Excel MVP "Rich" wrote in message ... Hi All I am trying to set the "table_array' part of this formula an individual cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38 =VLOOKUP(A8,'15.04.08'!A3:K38,7) Basically trying to define which worksheet to look in for the value. Hope this makes sense Cheers |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell VLookup
Sorry my error works a treat thanks for your help much appreciated "Rich" wrote: Hi Biff just tried this with no joy, responds with a #Ref error, and yes the lookup is the same range on each sheet "T. Valko" wrote: I'm assuming the lookup table is in the *same* range on the different sheets. A7 = sheet name = 15.04.08 =VLOOKUP(A8,INDIRECT("'"&A7&"'!A3:K38"),7) -- Biff Microsoft Excel MVP "Rich" wrote in message ... Hi All I am trying to set the "table_array' part of this formula an individual cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38 =VLOOKUP(A8,'15.04.08'!A3:K38,7) Basically trying to define which worksheet to look in for the value. Hope this makes sense Cheers |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell VLookup
Sorry my error works a treat
Thanks for your help, much appreciated "Rich" wrote: Hi Biff just tried this with no joy, responds with a #Ref error, and yes the lookup is the same range on each sheet "T. Valko" wrote: I'm assuming the lookup table is in the *same* range on the different sheets. A7 = sheet name = 15.04.08 =VLOOKUP(A8,INDIRECT("'"&A7&"'!A3:K38"),7) -- Biff Microsoft Excel MVP "Rich" wrote in message ... Hi All I am trying to set the "table_array' part of this formula an individual cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38 =VLOOKUP(A8,'15.04.08'!A3:K38,7) Basically trying to define which worksheet to look in for the value. Hope this makes sense Cheers |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell VLookup
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Rich" wrote in message ... Sorry my error works a treat Thanks for your help, much appreciated "Rich" wrote: Hi Biff just tried this with no joy, responds with a #Ref error, and yes the lookup is the same range on each sheet "T. Valko" wrote: I'm assuming the lookup table is in the *same* range on the different sheets. A7 = sheet name = 15.04.08 =VLOOKUP(A8,INDIRECT("'"&A7&"'!A3:K38"),7) -- Biff Microsoft Excel MVP "Rich" wrote in message ... Hi All I am trying to set the "table_array' part of this formula an individual cell. For '15.04.08'!A3:K38 as cell A7 or cell A7!A3:K38 =VLOOKUP(A8,'15.04.08'!A3:K38,7) Basically trying to define which worksheet to look in for the value. Hope this makes sense Cheers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use vlookup in excell 2007? | Excel Discussion (Misc queries) | |||
| Excell Vlookup formula | Excel Worksheet Functions | |||
| How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
| create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
| how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) | |||
Hybrid Mode
