Adjacent excel cells show same cell address on using cell address formula

Question

I require the cell address values in order to build a different solution, but I am unable to obtain the exact address. Everyone is capable of making repairs and obtaining the precise cell addresses of cells that are close to one another.

Answer 1

Use the reference argument:

=CELL("address",L54)

From the docs:

reference: The cell that you want information about.

Optional

If omitted, the information specified in the info_type argument is returned for cell selected at the time of calculation. If the reference argument is a range of cells, the CELL function returns the information for active cell in the selected range.