| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Value of a Cell in the Range Reference in VLOOKUP
I am trying to use the value of cell to be the reference to a named range in
a VLOOKUP function: =VLOOKUP(Value,$A$2,A1,false) in cell A2 would be entered the named range value, i.e., "Data" I know that I can use references for the lookup and the offset values. Any ideas? Can I automate VLOOKUP with this much flexibility? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Value of a Cell in the Range Reference in VLOOKUP
Use the INDIRECT function. Replace...
$A$2 with INDIRECT($A$2) Hope this helps! http://www.xl-central.com In article , Yangtze wrote: I am trying to use the value of cell to be the reference to a named range in a VLOOKUP function: =VLOOKUP(Value,$A$2,A1,false) in cell A2 would be entered the named range value, i.e., "Data" I know that I can use references for the lookup and the offset values. Any ideas? Can I automate VLOOKUP with this much flexibility? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup with range reference | Excel Discussion (Misc queries) | |||
| VLOOKUP using a tab name to reference the lookup range | Excel Discussion (Misc queries) | |||
| VLOOKUP variable range cell reference | Excel Worksheet Functions | |||
| Vlookup - dynamic range reference? | Excel Discussion (Misc queries) | |||
| use a cell to reference a range in a vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
