Excel ADDRESS Function (Example + Sample File)

What is EXCEL ADDRESS FUNCTION

The Excel ADDRESS Function is listed under Microsoft Excel’s Lookup Functions category. It returns a valid cell reference as per the column and row address. In simple words, you can create an address of a cell by using its row number and column number.

How to use it

To learn how to use ADDRESS function in Excel, you need to understand its syntax and arguments:

Syntax

ADDRESS(row_num,column_num,abs_num,A1,sheet_text)

Arguments

  • row_num: A number to specify row number.
  • column_num: A number to specify column number.
  • [abs_num]: Reference type.
  • [A1]: Reference style.
  • [sheet_text]: A text value as a sheet name.

Notes

  • By default, the ADDRESS function returns absolute reference in the result.

Example

To master ADDRESS function we need to try out an example, so make sure to check out the below one:

In the below example, we have used different arguments to get all types of results.

With R1C1 reference style:

  • Relative reference.
  • Relative row and absolute column reference.
  • Absolute row and relative column reference.
  • Absolute reference.

With A1 reference style:

  • Relative reference.
  • Relative row and absolute column reference.
  • Absolute row and relative column reference.
  • Absolute reference.

Hey Listen,

Make sure to check out this Basic Excel Tutorial, this is a guide that will help you to get started with Excel, and after that, here we have a list of EXCEL‌ TIPS to make you an advanced Excel user in no time.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

COPYRIGHT © 2020 • EXCEL CHAMPS

PRIVACY POLICYTERMS OF SERVICE