How to Use ADDRESS Function in Google Sheets

How to Use ADDRESS Function in Google Sheets

Honestly I thought It was a waste of my time for me learning the ADDRESS function in Google Sheets. But later I realised the worthiness of this function. I will come to that. First you should learn how to use Address Function in Google Sheets. After learning the use of this formula, we can go to an awesome tutorial using Address formula in Google Doc Spreadsheets. A rare combo that would do wonder with ranges in your formula.

No more suspense. In my leisure, I did some experiment with Google Sheets Address function and found out a way to create Dynamic SUM ranges in Google Sheets, that without any additional column or cell reference! It’s sheer magic! First let us learn the use of Address Function.

How to Use ADDRESS Function in Google Sheets


The purpose of Address function is to return a cell reference or cell address as text as per the specified row and column numbers and other references.


This time you should give importance to the Syntax part. Here it’s.

ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])

It’s a long syntax. I will come to each elements in this syntax with the help of a chart.┬áSee the chart below where I’ve used colour patterns to reveal everything about the Address Function Syntax elements.

Google Sheets Address Function Syntax Explained

Few More Examples to Google Sheets Address Function:

You can use ROW, COLUMN functions within Address function as below to get the cell address.

Formula: =address(row(H8),column(A1))
Result: $A$8

There are more use of Google Sheets Address function in combination with other functions. I’ll come to that in separate tutorials. Hope you could understand how to use ADDRESS Function in Google Sheets.


In the first para of this tutorial, I’ve mentioned about dynamic ranges. Yes, You can create dynamic ranges in Google Sheets Using a rare combination of ADDRESS function with other two functions. That tutorial is in the pipeline. The below link will be live once I complete that tutorial.

Dynamic Ranges Using Address Function in Google Sheets.

Other Tutorials Related to Dynamic Ranges in Google Sheets:

1. Dynamic Ranges Using OFFSET function.

2. Dynamic Ranges in SUMIF in Google Sheets.

That’s all for now. Enjoy!


Please enter your comment!
Please enter your name here