Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Table-array with a cell reference in vlookup
I have created a named range. I use the name of the range as the second
argument in the vlookup function and the function works fine. I would like to replace the name of the range with a cell reference. The cell being referred to indicates the name of the range. When I do this, the function ceases to work. Can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Table-array with a cell reference in vlookup
Allan
Try this =VLOOKUP(D1,INDIRECT(A1),2,FALSE) Where A1 contains the name of your named range Mike "Allan" wrote: I have created a named range. I use the name of the range as the second argument in the vlookup function and the function works fine. I would like to replace the name of the range with a cell reference. The cell being referred to indicates the name of the range. When I do this, the function ceases to work. Can this be done? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Table-array with a cell reference in vlookup
Try INDIRECT
eg in say, C2: =VLOOKUP(B2,INDIRECT(A2),2,0) where A2 contains the named range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Allan" wrote: I have created a named range. I use the name of the range as the second argument in the vlookup function and the function works fine. I would like to replace the name of the range with a cell reference. The cell being referred to indicates the name of the range. When I do this, the function ceases to work. Can this be done? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Table-array with a cell reference in vlookup
Thank-you
"Mike H" wrote: Allan Try this =VLOOKUP(D1,INDIRECT(A1),2,FALSE) Where A1 contains the name of your named range Mike "Allan" wrote: I have created a named range. I use the name of the range as the second argument in the vlookup function and the function works fine. I would like to replace the name of the range with a cell reference. The cell being referred to indicates the name of the range. When I do this, the function ceases to work. Can this be done? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing a Table-array with a cell reference in vlookup
your welcome
"Allan" wrote: Thank-you "Mike H" wrote: Allan Try this =VLOOKUP(D1,INDIRECT(A1),2,FALSE) Where A1 contains the name of your named range Mike "Allan" wrote: I have created a named range. I use the name of the range as the second argument in the vlookup function and the function works fine. I would like to replace the name of the range with a cell reference. The cell being referred to indicates the name of the range. When I do this, the function ceases to work. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP keeping array lookup reference | Excel Discussion (Misc queries) | |||
use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) |