• 4 years ago
In this video you will learn about Ms Excel Lookup and Reference Group Function #OFFSET() optional reference Height and Width
By using height ad width in OFFSET you can create a dynamic range without selecting range of Excel worksheet

To know more about it watch this video till the end

Download Practice File Here
https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY
Check other videos in the following link too
https://www.youtube.com/channel/UCcut-zPImQ1wefD9sq8DQZw/
https://www.youtube.com/c/belookup

Offset Function Part-1
https://youtu.be/t5iWwWg80ZA

Ms Excel Match Function
https://youtu.be/eJNIGfZ6Hq0

XLOOKUP Function
https://youtu.be/15ziUhOp-3M

LOOKUP Function in Excel
https://youtu.be/8nCotivDIMU


#Excel_Universe,#XLOOKUP, #LOOKUP, #OFFSET,#MATCH