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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com