In this video you will learn about Ms Excel Lookup and Reference Group Function #OFFSET() optional reference Height and Widthbr By using height ad width in OFFSET you can create a dynamic range without selecting range of Excel worksheetbr br To know more about it watch this video till the endbr br Download Practice File Herebr Check other videos in the following link toobr br Offset Function Part-1br br Ms Excel Match Functionbr br XLOOKUP Functionbr br LOOKUP Function in Excelbr br br #ExcelUniverse,#XLOOKUP, #LOOKUP, #OFFSET,#MATCH