Lookup & Reference functions in Excel

Hello all. In this section, let’s look into all the Lookup & Reference functions available in Excel. The below table lists out the function and its usage / syntax. Function Usage Syntax ADDRESS Returns the address of the cell based on row & column number =address(row_num,col_num,[abs_num],[a1],[sheet]) AREAS Returns the number of areas in a reference.Continue reading “Lookup & Reference functions in Excel”