| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup using a reference to a named range?(Excel 2000)
When inputting the table_array information in a Vlookup formula you can
either input a range of cells or named range. My named range changes monthly so I tried to use a cell reference in the Vlookup formula to capture the new named range but the formula returns N/A# error? i.e. cell A1 "Mth_1" formula: =Vlookup("Sales",A1,2,false) The formula works is if the named range "Mth_1" is included as part of the formula instead of reference to a cell that contains the name of the range to lookup. Any suggestions? I am trying to make the update process quicker than performing a fine and replace on multiple tabs. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup using a reference to a named range?(Excel 2000)
One way:
=VLOOKUP("Sales",INDIRECT(A1),2,FALSE) In article , Joe wrote: When inputting the table_array information in a Vlookup formula you can either input a range of cells or named range. My named range changes monthly so I tried to use a cell reference in the Vlookup formula to capture the new named range but the formula returns N/A# error? i.e. cell A1 "Mth_1" formula: =Vlookup("Sales",A1,2,false) The formula works is if the named range "Mth_1" is included as part of the formula instead of reference to a cell that contains the name of the range to lookup. Any suggestions? I am trying to make the update process quicker than performing a fine and replace on multiple tabs. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup using a reference to a named range?(Excel 2000)
Try it like this...
As long as the named range isn't really a named formula: =VLOOKUP("Sales",INDIRECT(A1),2,0) -- Biff Microsoft Excel MVP "Joe" wrote in message ... When inputting the table_array information in a Vlookup formula you can either input a range of cells or named range. My named range changes monthly so I tried to use a cell reference in the Vlookup formula to capture the new named range but the formula returns N/A# error? i.e. cell A1 "Mth_1" formula: =Vlookup("Sales",A1,2,false) The formula works is if the named range "Mth_1" is included as part of the formula instead of reference to a cell that contains the name of the range to lookup. Any suggestions? I am trying to make the update process quicker than performing a fine and replace on multiple tabs. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup using a reference to a named range?(Excel 2000)
Thx for the fast response - it works great!
"T. Valko" wrote: Try it like this... As long as the named range isn't really a named formula: =VLOOKUP("Sales",INDIRECT(A1),2,0) -- Biff Microsoft Excel MVP "Joe" wrote in message ... When inputting the table_array information in a Vlookup formula you can either input a range of cells or named range. My named range changes monthly so I tried to use a cell reference in the Vlookup formula to capture the new named range but the formula returns N/A# error? i.e. cell A1 "Mth_1" formula: =Vlookup("Sales",A1,2,false) The formula works is if the named range "Mth_1" is included as part of the formula instead of reference to a cell that contains the name of the range to lookup. Any suggestions? I am trying to make the update process quicker than performing a fine and replace on multiple tabs. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup using a reference to a named range?(Excel 2000)
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Joe" wrote in message ... Thx for the fast response - it works great! "T. Valko" wrote: Try it like this... As long as the named range isn't really a named formula: =VLOOKUP("Sales",INDIRECT(A1),2,0) -- Biff Microsoft Excel MVP "Joe" wrote in message ... When inputting the table_array information in a Vlookup formula you can either input a range of cells or named range. My named range changes monthly so I tried to use a cell reference in the Vlookup formula to capture the new named range but the formula returns N/A# error? i.e. cell A1 "Mth_1" formula: =Vlookup("Sales",A1,2,false) The formula works is if the named range "Mth_1" is included as part of the formula instead of reference to a cell that contains the name of the range to lookup. Any suggestions? I am trying to make the update process quicker than performing a fine and replace on multiple tabs. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup - using a cell to reference a named array | Excel Worksheet Functions | |||
| reference first cell in a named range | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| named range, offset self-reference | Excel Discussion (Misc queries) | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
Hybrid Mode
