Address function is all about pointing out the cell particulars. For example, if an entry is on cell B2 then the address for the same is B2.

Previously In Excel Formulas: How to use ACCRINTM Function in Excel?

Here’s a detailed explanation of the same:

ADDRESS Function

The image given above is an example to explain the address function. 

As you can observe the presence of entries to know the address of a particular, here’s what we do:

Step1: Input the Formula

The Address formula is as follows:


ADDRESS Function

The formula requires the following values:

  • Row number- In the same, all you have to do is select the cell of the number you want to identity the address of.
  • Column number- Same as row number but taking column.
  • Abs_num: This is an option, for if you want your answer to be absolute or relative.
  • Style: You can either have your address in R1C1 Style or A1 Style. 
  • R1C1 style is basically where the Row value as well as column value will be shown.
  • A1 style consists of letters and digits, which uniquely describes your cell address.

Step2: Input the values in the Formula

ADDRESS Function
ADDRESS Function

As we have shown that we have selected product_id 212 as our row number, and column number as 434 of product code.

ADDRESS Function

Coming to the point of relative or absolute number, we will pick option 1. The only difference that displays on the screen between the both is that in absolute it would be written as R2C3 and in relative it would be written as R(2)C(3).

ADDRESS Function

After choosing the absolute or relative number, we need to pick a style, so lets go with R1C1 Style.

ADDRESS Function

And there it is, your address: R212C434.

If we talk about A1 style, then we have to do the exact same process the way we did in R1C1 Style.

ADDRESS Function

After choosing Option 1, A1 Style, press enter.

ADDRESS Function

And there you go with your address of the chosen cells in A1 Style.

ADDRESS Function

It’s easy, isn’t it?