In this video you will learn about Ms Excel Lookup and Reference Group Function #OFFSET(), 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.
In this video I have explain in detail of the basic of OFFSET that how to lookup data using with #MATCH Function.
To know more about it watch this video till the end
Download Practice File Here https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY
Check other excel videos in the following link too https://www.youtube.com/channel/UCcut-zPImQ1wefD9sq8DQZw/ https://www.youtube.com/c/belookup
Ms Excel Match Function https://youtu.be/eJNIGfZ6Hq0
XLOOKUP Function https://youtu.be/15ziUhOp-3M
LOOKUP Function in Excel https://youtu.be/8nCotivDIMU
