Learn How to Get the Address of the Lookup Result in Microsoft Excel
The main purpose of this formula is to get the address of a lookup result. Here we will learn how to get the address of lookup results in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the INDEX and CELL functions, you can able to get the address of a lookup result.
So, with the help of this formula, you can able to get the address of the lookup result in the given data range in the workbook in Microsoft Excel.
General Formula to Get Address of Lookup Result
=CELL(“address”,INDEX(range,row,col))
The Explanation to Get the Address of Lookup Result
So we know that with the help of the given formula above you can able to get the address of a lookup result. Here we will learn how to get the address of lookup results in the given data range in the workbook in Microsoft Excel.
As we know that the INDEX function actually returns a reference to the cell specified in the C column. When you wrap the INDEX in the CELL function, we can get the formula to show us the address to the cell returned by INDEX.
After INDEX returns a reference So now you have learned how to get the address of lookup results in the given data range in the workbook in Microsoft Excel.