How to use the Index Function
Exercise files: https://www.computertutoring.co.uk/how_to_use_index_function.asp
The Index Match function is an extremely handy function. It allows you, in effect to create a VLookup but the lookup column doesn't have to be in the left most column. However how does the Index function actually work.
This video will allow you to become familiar with the Index function. The Index function will look at an array or range of cells and bring back a value in the cell by typing in a number in the function arguments.
#computertutoring
😊 Check out my website and social media to keep up to date - enjoy learning 😊
📱 http://www.computertutoring.co.uk/ 📱
📽 https://www.tiktok.com/@thecomptutor 📽
👨👩👧👦 https://www.facebook.com/ComputerTutoring.co.uk/ 👨👩👧👦
🦉 https://twitter.com/CT_Tutoring 🦉
📷https://www.instagram.com/computer_tutoring/ 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌
Видео How to use the Index Function канала Computer Tutoring
The Index Match function is an extremely handy function. It allows you, in effect to create a VLookup but the lookup column doesn't have to be in the left most column. However how does the Index function actually work.
This video will allow you to become familiar with the Index function. The Index function will look at an array or range of cells and bring back a value in the cell by typing in a number in the function arguments.
#computertutoring
😊 Check out my website and social media to keep up to date - enjoy learning 😊
📱 http://www.computertutoring.co.uk/ 📱
📽 https://www.tiktok.com/@thecomptutor 📽
👨👩👧👦 https://www.facebook.com/ComputerTutoring.co.uk/ 👨👩👧👦
🦉 https://twitter.com/CT_Tutoring 🦉
📷https://www.instagram.com/computer_tutoring/ 📷
📌https://www.pinterest.co.uk/CT_Training/ 📌
Видео How to use the Index Function канала Computer Tutoring
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Pivot Table Slicer with Filter](https://i.ytimg.com/vi/roqgIdlYCq4/default.jpg)
![Excel Index Match](https://i.ytimg.com/vi/Vq8p2oangcI/default.jpg)
![Excel VLookup Example](https://i.ytimg.com/vi/_q2ZwHvE69Y/default.jpg)
![Using Form Wizard in Access 2016 - Creating an Access database](https://i.ytimg.com/vi/dm1vqg6Lnvo/default.jpg)
![Liquid Layout - InDesign Training](https://i.ytimg.com/vi/jVTI6vGhW8g/default.jpg)
![Using the SUMIF function in Excel](https://i.ytimg.com/vi/S5tq7ry-5Wg/default.jpg)
![Use Google Sheets VLookup to do customer classification](https://i.ytimg.com/vi/J1cnC68IPuc/default.jpg)
![Year to Date Power BI Tutorial](https://i.ytimg.com/vi/Lz8y4xUj1uE/default.jpg)
![Set up gmail Account in Outlook 2016](https://i.ytimg.com/vi/i2GfGMM9TV0/default.jpg)
![Perspective Grid Tool Illustrator CC](https://i.ytimg.com/vi/xUAiLrBTsn8/default.jpg)
![Zoom Tutorial: What to do if you have to host a meeting?](https://i.ytimg.com/vi/uy1b1J8ix8U/default.jpg)
![Photoshop Pen Tool Combo Paths](https://i.ytimg.com/vi/fzMcQyknJFg/default.jpg)
![Excel Building Data Models with PowerPivot - Access Database](https://i.ytimg.com/vi/1OvdeLQt4sE/default.jpg)
![Excel Pivot Count Distinct in 2013 onward](https://i.ytimg.com/vi/1-aga-9Cn-0/default.jpg)
![How to use Outlook Email Rules?](https://i.ytimg.com/vi/aNLZEs-n9VM/default.jpg)
![PowerBI Tutorial Cumulative Totals for a Financial Year](https://i.ytimg.com/vi/ylZa7_uiNq4/default.jpg)
![Use PowerPoint to Speak another Language](https://i.ytimg.com/vi/GqsCLPA6AuE/default.jpg)
![How to Make Your Accounts Look Good in Excel?](https://i.ytimg.com/vi/qWkXvOdochA/default.jpg)
![Easy Power Query Tutorial on Removing Blank Rows](https://i.ytimg.com/vi/vFnD7bmVyzc/default.jpg)
![Creating your first page using Dreamweaver - Part 2](https://i.ytimg.com/vi/ski5N1Q6O1c/default.jpg)