Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 2 of 2
Вставка
- Опубліковано 13 січ 2013
- // Recommended Excel Courses //
1. Launch Excel Macros & VBA School: go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
Download the Sample workbook to follow with the video - visit this page on my website - www.launchexcel.com/dynamic-vl...
This tutorial helps you learn 3 ways to write a VLookup formula to make it dynamic.
- Simple method (type in numbers for column index number)
- Using COLUMN function to specify column index number
- Using MATCH function to specify column index number
You can find the full video transcript with more screenshots here: www.launchexcel.com/dynamic-vl...
Thank you. Vlookup with match function opens a whole new flexibility!
Your teaching efforts are appreciated. Your work product is good.
Very easy teaching , thank you
helped a lot thank you very much