Variable arrays

  • Thread starter Thread starter mouseman5
  • Start date Start date
M

mouseman5

I'm attempting to access different arrays based on the text in a cell
for example "hlookup(N1,T1,3)," where the contents of N1 and T1 ar
text. I get a cell reference error. When I use help to evaluate th
formula, N1 returns the proper value, but T1 returns $T$1 instead o
the text in the cell. Can I get the second argument to accept
variable
 
Hi
try
hlookup(N1,INDIRECT(T1),3,0)

Note: T1 has to store a valid reference. e.g. the text string: A1:C100
in your example
 
Back
Top