Excel function

  • Thread starter Thread starter Stephen Miles
  • Start date Start date
S

Stephen Miles

I want the 'ADDRESS' function to return an address which
can be used in 'HLOOKUP' to define the Table_array
 
Stephen Miles said:
I want the 'ADDRESS' function to return an address which
can be used in 'HLOOKUP' to define the Table_array
Click to expand...

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.
 
Back
Top