Return to Excel Formulas List

Lookup – return cell address instead of value – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will teach you how to retrieve the address of a looked-up cell instead of the value

Excel Lookup Return Cell Address Inst Main Function

Lookup Cell Address

To look up a cell address (instead of a cell value), we use the INDEX / MATCH Functions to find the range and the CELL Function to output the cell address:

Return Cell Address Instead of Value 01

We will walk through the formula below.

 

MATCH Functions

The MATCH Function looks for the invoice number and returns its row number:

Return Cell Address Instead of Value- Match

 

INDEX Function

The INDEX Function returns the cell value corresponding to the row returned by the MATCH Function above:

Return Cell Address Instead of Value INDEX

 

CELL Function – Retrieve Cell Attributes

The CELL Function retrieves specific attributes about a cell. Here we use the CELL Function to return the cell address, by inputting “address” into the first function argument:

Return Cell Address Instead of Value 01

Lookup – return cell address instead of value in Google Sheets

The example above works the same way in google sheets.

Excel Lookup Return Cell Address Inst Google Function