using OFFSET to refere to entire column (eg. $H:$H)

[acol]

referring to a cell by OFFSET(INDIRECT(ADDRESS(ROW();COLUMN()));0;-4) is easy
Although I want to replace "$H:$H" in a formula by an OFFSET function referring to the entire column 4 columns to the current cell (column)
How can that be done?

example: =TEXTJOIN(", ";TRUE;IF($H:$H = E5;$I:$I;""))
instead of $H:$H i want to refer to that column via OFFSET

Any help very much appreciated.

 

[RoryA]

Is there a reason you can't just use relative referencing?

 

[acol]

Is there a reason you can't just use relative referencing?

Not clear to me that one... (sorry) ;(
results of formula must stay intact when filtering and sorting

 

[RoryA]

A full column reference like H:H won't be altered by filtering or sorting.

 

[acol]

A full column reference like H:H won't be altered by filtering or sorting.

Ok. Thx
But can it be done by code?

 

[RoryA]

Can what be done by code exactly?

 

[acol]

Can what be done by code exactly?

using the OFFSET function to refer to a column, x places away to the current cell.
Anyway, since refering to entire columns doesn't affect sorting or filtering, there is no need for a change.
(it is when referring to cells however).
Thx for your feedback.