Excel function

[Stephen Miles]

I want the 'ADDRESS' function to return an address which
can be used in 'HLOOKUP' to define the Table_array

 

[Paul]

I want the 'ADDRESS' function to return an address which
can be used in 'HLOOKUP' to define the Table_array

The ADDRESS function returns a single cell address as text. This could be
converted to an actual cell reference using INDIRECT, but: (a) this would
still be a single cell reference (rather than a table array); and (b) why
would you make an address in text format and then convert to a reference
when you could simply make that reference in the first place? I suspect you
probably want the OFFSET function, not ADDRESS. Post back with details of
what you want to achieve for more help.