ADDRESS

傳回字串形式的儲存格參照。

使用範本

ADDRESS(1,2)

ADDRESS(1,2,4,FALSE)

ADDRESS(1,2,,,"Sheet2")

語法

ADDRESS(列, 欄, [絕對相對模式], [使用_a1_表示法], [工作表])

• 列 - 儲存格參照的列號

• 欄 - 儲存格參照的欄號 (而非資料欄名稱)。A is column number 1.

• 絕對相對模式 - [ OPTIONAL - 1 by default ] - 指明參照的列/欄是否為絕對。1 is row and column absolute (e.g. $A$1), 2 is row absolute and column relative (e.g. A$1), 3 is row relative and column absolute (e.g. $A1), and 4 is row and column relative (e.g. A1).

• 使用_a1_表示法 - [ OPTIONAL - TRUE by default ] - A boolean indicating whether to use A1 style notation (TRUE) or R1C1 style notation (FALSE).

• 工作表 - [ OPTIONAL - absent by default ] - A string indicating the name of the sheet into which the address points.

附註

• When using optional parameters such as 「 」工作表, ensure that commas are inserted to indicate which parameter is being set.

另請參閱

OFFSET: 傳回開首儲存格參照內的指定欄/列數之範圍參照。

MATCH: 傳回與指定值相符的項目在範圍中的相對位置。

INDEX: 傳回以列偏移和欄偏移方式指定的儲存格內容。

範例

Returns the cell address (reference) as text, according to the specified row and column numbers, using different types of reference.