Lookup functions are essentially used to match lookup from one data set and finding the corresponding entry or output from another data set. It is divided into two parts - lookup and reference functions.
Here we discuss the top lookup and reference functions in excel
ADDRESS function in Excel
VLOOKUP and HLOOKUP in excel
MATCH and INDEX Functions in Excel
COLUMN and COLUMNS in Excel
INDIRECT function in Excel
REPLACE function in Excel
Address Function in Excel
Address function in Excel lets you derive the reference excel address of cell or a range passed in the parameter of the Address function Excel.