ADDRESS returns a string with a cell’s address
Use ADDRESS to return a text representation of a cell address based on the row, column, and sheet; ADDRESS is frequently used with MATCH. The supported forms for ADDRESS are as follows:
ADDRESS(row; column; abs)
ADDRESS(row; column; abs; sheet)
The row and column are integer values where ADDRESS(1; 1) returns $A$1. The abs argument specifies which portion is considered absolute and which portion is considered relative (see Table 10); an absolute address is specified using the $ character. The sheet is included as part of the address only if the sheet argument is used. The sheet argument is treated as a string. Using ADDRESS(MATCH("Bob";A1:A5 ; 0); 2) with the data in Error: Reference source not found returns $B$2.
|| Calc supports numerous powerful functions that are not discussed here. For example, the ROW, COLUMN, ROWS, and COLUMNS statements are not discussed; a curious person would investigate these functions.
Table 10. Values supported by the abs argument to ADDRESS.
|| Use absolute addressing. This is the default value if the argument is missing or an invalid value is used. ADDRESS(2; 5; 1) returns $E$2.
|| Use an absolute row reference and a relative column reference. ADDRESS(2; 5; 2; "Blah") returns Blah.E$2.
|| Use a relative row reference and an absolute column reference. ADDRESS(2; 5; 3) returns $E2.
|| Use relative addressing. ADDRESS(2; 5; 4) returns E2.