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.
Here’s a detailed explanation of the same:
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:
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
As we have shown that we have selected product_id 212 as our row number, and column number as 434 of product code.
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).
After choosing the absolute or relative number, we need to pick a style, so lets go with R1C1 Style.
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.
After choosing Option 1, A1 Style, press enter.
And there you go with your address of the chosen cells in A1 Style.
It’s easy, isn’t it?