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

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

 

AutoMacro - VBA Code Generator

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

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!