Get address of lookup result

To get the address of the result returned by the XLOOKUP function or the INDEX function, you can use the CELL function. In the example shown, the formula in cell F6 is: =CELL("address",XLOOKUP(F4,B5:B17,C5:C17)) The result is $C$10, the address of the cell returned by XLOOKUP. See below for an INDEX and MATCH example. Note: the CELL function is a volatile function and can cause performance problems in large or complex worksheets. It is used in this example to show how to troubleshoot or confirm a lookup result.

April 14, 2025 · 1 min · 101 words · Faith Murray

Table of Contents

Two of these functions areXLOOKUPandINDEX.

you’re able to check the reference returned by XLOOKUP or INDEX with theCELL function.

This can be useful when debugging a lookup formula to confirm the result being returned.

Excel formula: INDEX and MATCH case-sensitive

However, underneath the surface, XLOOKUP is actually returning areferenceto cell C10.

INDEX and MATCH

Like the XLOOKUP function, theINDEX functionis another function that returns an address.

The key in of information to be returned is specified asinfo_type.

Excel formula: XLOOKUP basic exact match

XLOOKUP supports approximate and exact matching, wildcards (* ?)

you might use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Excel CELL function

Excel XLOOKUP function

Excel INDEX function

Excel MATCH function