ExcelBanter - Current Cell location

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Current Cell location (https://www.excelbanter.com/excel-worksheet-functions/227938-current-cell-location.html)

HRHRLBS

Current Cell location

I am trying to use an OFFSET lookup command but need to tell the formula the
current location within the column. What formula displays my current cell
location?

Mike H

Current Cell location

Hi,

I'm not sure this will get you far but

=CELL("address")
=CELL("row")
=CELL("Column")

Mike

"HRHRLBS" wrote:

I am trying to use an OFFSET lookup command but need to tell the formula the
current location within the column. What formula displays my current cell
location?

All times are GMT +1. The time now is 05:01 AM.