Most people use cell references when writing formulas on Google Sheets.
But what if you don’t know the cell references you’re gonna wanna work with?
This is where the ADDRESS function comes in.
The ADDRESS function in Google Sheets will always return a reference in text string format to a single cell.
Read on to learn everything you need about the basics of Google Sheets' ADDRESS function.
When to use the ADDRESS Function
The ADDRESS function is a built-in function found in Google Sheets.
It belongs to the group of functions known as Lookup functions.
In short, it turns column and row numbers into cell addresses.
This function aims to construct a cell reference from a column and row number.
One might think that learning Google Sheets' ADDRESS function is a waste of time.
However, many of these arguments are optional and not often used.
They work the same in Google Sheets.
Study them and note the differences.
It’s not much use using the ADDRESS function on its own.
However, when paired with other features, it may be pretty valuable.
Let’s examine some instances to learn how.
INDIRECT and ADDRESS Functions.
The content of a specific cell reference held in another cell is shown using the INDIRECT function.
It is perfect forremoving circular referencesin your spreadsheet.
If we combine the INDIRECT and ADDRESS methods, we can easily retrieve the contents of any required cell.
But if we enclose it in an INDIRECT function, we can read the contents.
It is much more complicated than other search functions, such as XLOOKUP and VLOOKUP.
You’d mainly have to interact with the ADDRESS function when using other people’s spreadsheets.
If you’re building your own, we recommend using a LOOKUP function instead.
