How to use Index Function Array & Reference
- 4 years ago
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.
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.
I have provided the complete details in video with multiple example.
Request you to please watch this video till the end to understand better.
How to use Index Match in Excel
https://youtu.be/ORn3h4KoNp4
How to Create Table in Excel
https://youtu.be/keM0X9M2qAc
Download Practice File Here
https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY
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.
I have provided the complete details in video with multiple example.
Request you to please watch this video till the end to understand better.
How to use Index Match in Excel
https://youtu.be/ORn3h4KoNp4
How to Create Table in Excel
https://youtu.be/keM0X9M2qAc
Download Practice File Here
https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY