Offset Function in Excel Part-1
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.<br /><br />To know more about it watch this video till the end<br /><br />Download Practice File Here<br />https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY<br /><br />Check other excel videos in the following link too<br />https://www.youtube.com/channel/UCcut-zPImQ1wefD9sq8DQZw/<br />https://www.youtube.com/c/belookup<br /><br /><br />Ms Excel Match Function<br />https://youtu.be/eJNIGfZ6Hq0<br /><br />XLOOKUP Function<br />https://youtu.be/15ziUhOp-3M<br /><br />LOOKUP Function in Excel<br />https://youtu.be/8nCotivDIMU<br /><br /><br />#Excel_Universe,#XLOOKUP, #LOOKUP, #OFFSET,#MATCH