One of Excel's lesser known lookup and reference functions is the ROW function.
This function is often combined with other functions, such as INDEX, to create versatile lookup formulas.
The ROW function can be used in two ways.
One, it can be used to return the number of the ROW for the cell where the function is located in the worksheet.
Two, it can be used to return the number for a ROW of a given cell reference.
To find out all the details on how this function works, read this short tutorial on the Excel ROW Function.Excel Lookup Formula Tutorials