How to use Index Function Array & Reference
In this video you will learn about Index Function Reference Arguments, in Part-1, you learn about array from that will help you to lookup data from a single table or data range.<br />Although you know the INDEX function having 2 arguments, and if you want to lookup data from multiple table you need to use reference form.<br />I have provided the complete details in video with multiple example.<br /><br />Request you to please watch this video till the end to understand better.<br /><br />How to use Index Match in Excel<br />https://youtu.be/ORn3h4KoNp4<br /><br />How to Create Table in Excel<br />https://youtu.be/keM0X9M2qAc<br /><br /><br />Download Practice File Here<br />https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY