Download the example workbook
This tutorial will demonstrate how to retrieve the address of a looked-up cell instead of the value
Lookup Cell Address
We will walk through the formula below.
The MATCH Function looks for the invoice number and returns its row number:
The INDEX Function returns the cell value corresponding to the row returned by the MATCH Function above:
CELL Function – Retrieve Cell Attributes
The CELL Function retrieves specific attributes about a cell. Here we calculate the cell address by inputting “address”:
Lookup – return cell address instead of value in Google Sheets
The example above works the same way in Google Sheets.