Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Lookup and reference Excel ADDRESS Function

Excel ADDRESS Function

You can use the Excel ADDRESS function to get the address for cells in a worksheet, based on particular rows and columns. This function returns an address either in a relative or absolute format. This article provides a clear guide on how to use the Excel ADDRESS function.

Figure 1. Final result

Syntax of the formula

=ADDRESS (row_num, col_num, [abs_num], [a1], [sheet])

Where;

  • Row_num- refers the row number we want to use in the cell address
  • Col_num- refers to the column number we want to use the cell address
  • Abs_num– address type. The default of the address type is absolute. This is optional and can be ignored.
  • A1- refers to the reference style, which is also optional. Default style is A1.
  • Sheet– identifies the name of the worksheet we want to use. Default is the current sheet, and it is optional as well.

Understanding the ADDRESS function

This function is fundamental when we want to get the address of a given cell based on a given row and column. The formula returns a cell address in from the given worksheet. This function returns the cell address in either absolute format or relative format.

Example 1

To further understand how the Excel ADDRESS function works, we shall look at an example where we shall fetch the address from a specified row and column.

Figure 2. Example 1

In this example, the ‘result’ column shows the address for the specified rows and columns in the worksheet.

Note

There are four keys that can help us define the Abs_num, these are;

  • Omitted absolute
  • Relative row; absolute column
  • Absolute row; relative column
  • Relative

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc