Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - using a cell to reference a named array
I have a file that contains several options for the named table array. In a
menu the user identifies what the criteria is and this drives lookups to determine the name of the array. I am then using this cell reference in my vlookup. However it appears the formula will not accept a cell reference for a named array. Does anyone have another solution? =VLOOKUP(D9,F5,12,FALSE) where F5 is a calculated value for the table named table array. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - using a cell to reference a named array
=VLOOKUP(D9,INDIRECT(F5),12,FALSE)
"Ronin" wrote: I have a file that contains several options for the named table array. In a menu the user identifies what the criteria is and this drives lookups to determine the name of the array. I am then using this cell reference in my vlookup. However it appears the formula will not accept a cell reference for a named array. Does anyone have another solution? =VLOOKUP(D9,F5,12,FALSE) where F5 is a calculated value for the table named table array. thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - using a cell to reference a named array
Gracias
"Teethless mama" wrote: =VLOOKUP(D9,INDIRECT(F5),12,FALSE) "Ronin" wrote: I have a file that contains several options for the named table array. In a menu the user identifies what the criteria is and this drives lookups to determine the name of the array. I am then using this cell reference in my vlookup. However it appears the formula will not accept a cell reference for a named array. Does anyone have another solution? =VLOOKUP(D9,F5,12,FALSE) where F5 is a calculated value for the table named table array. thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup - using a cell to reference a named array
You're Welcome!
"Ronin" wrote: Gracias "Teethless mama" wrote: =VLOOKUP(D9,INDIRECT(F5),12,FALSE) "Ronin" wrote: I have a file that contains several options for the named table array. In a menu the user identifies what the criteria is and this drives lookups to determine the name of the array. I am then using this cell reference in my vlookup. However it appears the formula will not accept a cell reference for a named array. Does anyone have another solution? =VLOOKUP(D9,F5,12,FALSE) where F5 is a calculated value for the table named table array. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
reference first cell in a named range | Excel Worksheet Functions | |||
VLOOKUP keeping array lookup reference | Excel Discussion (Misc queries) | |||
use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions |