Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing a Table-array with a cell reference in vlookup Allan Excel Worksheet Functions 4 January 15th 08 02:57 PM
reference first cell in a named range Robert H Excel Worksheet Functions 3 January 14th 08 08:53 PM
VLOOKUP keeping array lookup reference rebdk Excel Discussion (Misc queries) 3 July 4th 06 08:46 PM
use cell reference,whose contents= a table array name for Vlookup Sonic Excel Worksheet Functions 2 March 27th 06 08:29 AM
Using single cell reference as table array argument in Vlookup CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"