In this video you will learn about Ms Excel Lookup and Reference Group Function #OFFSET(), br The OFFSET function returns a range of cells that is specified number of rows and columns from the specified range. This function is very good for creating dynamic ranges and automation in Excel reports.br br In this video I have explain in detail of the basic of OFFSET that how to lookup data using with #MATCH Function.