ADDRESS
Returns a cell reference as a string, given the row and column numbers.
Syntax
row: A number specifying the row. E.g. 1
1- Row and column absolute ($A$1)
2- Row absolute and column relative (A$1)
3- Row relative and column absolute ($A1)
ref_type: A logical value that determines whether the reference style is A1 (TRUE) or R1C1 (FALSE). The value is set as TRUE by default.
Remarks
When omitting an optional parameter in the syntax, use a ; or , to separate it from the next argument. For example, in =ADDRESS(1;2;;TRUE;"ADDRESS") the parameter mode has been omitted.
Examples
Formula | Result |
=ADDRESS(1;2;1;TRUE;"ADDRESS") | ADDRESS.$B$1 |
=ADDRESS(1;2;1;TRUE) | $B$1 |
=ADDRESS(1;2;2) | B$1 |
=ADDRESS(1;2;1;FALSE;"ADDRESS") | ADDRESS.R1C2 |
Possible Errors
Errors | Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
HYPERLINK
Creates a hyperlink inside a cell that, when clicked, opens the address specified. Syntax HYPERLINK(link_address; [cell_text]) link_address: The URL or address to open. In case of a cell reference, use "#cell_reference". E.g. " www.zoho.com" ...Insert a hyperlink
To insert a hyperlink: Tap the cell you wish to add hyperlink to. Under the Insert menu, tap Link. Select the link type, specify the link address, and the display format from the respective drop-downs. Once you're done, tap Add at the top-right ...Insert a hyperlink in a sheet
To insert button: Select the cell you want the hyperlink to be in. Click Insert > hyperlink. There are different places you can point to, using a hyperlink. In Zoho Sheet, you can link to a webpage, a place within the document, a telephone number or ...Share spreadsheet for collaboration
To share a spreadsheet with others: Go to ••• > Add People in the listing page or spreadsheet editor. Enter the email address of the desired people you want to share the file with, set the access permission, and tap Share. If you are using Zoho ...Hyperlink data in a cell
To insert hyperlinks: Choose the desired cell or data. Go to the icon Under the Insert menu, choose Link. Choose the type of link to insert, and enter the URL, cell range, or email address respectively. To display a different text on the cell, enter ...