ADDRESS(row_num,col_num,abs_num,a1,text)
row_num: row number
col_num: column number
abs_num: 1 for an absolute, 2 for a row absolute and column relative, 3 for a row relative and column absolute, and 4 for a relative reference; defaults to 1
a1: if TRUE, an A1-style reference is provided, otherwise an R1C1-style reference; defaults to TRUE
text: name of the worksheet, defaults to no sheet
If row_num or col_num is less than one, ADDRESS returns #VALUE! If abs_num is greater than 4 ADDRESS returns #VALUE!