The column function returns the number of the column, so for example if I am in column A then =COLUMN() will return 1, and if I am in column BT then =COLUMN() will return 72.
I need a function which return the column identifier as text, so for example if I am in comumn BT I’d like to have “BT” returned to me.
To get a cell address to call INDIRECT() with you can use ADDRESS(rowNum; colNum) directly. Concatenation of the address based on any workarounds is a useless complication in most cases.
Anyway the OFFSET() function should often be preferrable, in specific as it also easily creates references to cell ranges where the concatenation of range addresses is a mess…
It works, thanks. Still, it’s such a useful function for indirect addressing I thought there should be a native function.
Concerning the coulumn names you have a rather efficient workaround as @JohnSUN showd you, and you actually can use the COLUMN() number for indirect addressing (preferrably).
It’s different with sheets: You only get the SHEET() number, but to create an indirect reference into a different sheet you need tzhe name of the sheet. This is seriously aggravated if users insist of giving pseudonames containing spaces and special characters to sheets. These names need to be “singlequted” then with internall yinglequotes doubled. There is no “cheap” workaround at hand - and nbody seems to care.
Be happy to only want column names - and consider my suggestion to always use column numbers for indirect addressing. .