reference an array name via a cell reference

[stewbrown]

Thanks for the help on my previous question! I would like to use an array name in the vlookup function instead of a cell range. But I want have the array name in a cell that can be referenced:

vlookup($a1,$t$4,2,false)

where cell t4 contains the name of the array. This of course does not work. Any sugestions? Thanks.

 

[Aladin Akyurek]

On 2002-09-24 11:43, stewbrown wrote:
Thanks for the help on my previous question! I would like to use an array name in the vlookup function instead of a cell range. But I want have the array name in a cell that can be referenced:

vlookup($a1,$t$4,2,false)

where cell t4 contains the name of the array. This of course does not work. Any sugestions? Thanks.

=VLOOKUP($A1,INDIRECT($T$4),2,0)

Don't do this if not really needed for INDIRECT is a volatile function that prolongs the recalc time.