How to Use Excel Function VLOOKUP - Complete Advanced Tutorial Video with Subtitle, 9 Examples

preview_player
Показать описание
In this video, I explained What is VLOOKUP in Excel and how you can get the best of it with Master trick. Here is the Blog article for this :

This video explains how you can write VLOOKUP Function. Watch this video to learn this VLOOKUP with simple method with Subtitles

Below are the topics covered:

00:00 1. Introduction
00:16 2. What is Vlookup Formula?
00:32 3. VLOOKUP Simple Example (First Method)
00:58 4. VLOOKUP Function Arguments Explained
02:00 5. Write VLOOKUP Function
02:56 6. Cell Reference Absolute and Relative
04:53 7. Use Vlookup Function with Multiple Criteria
07:58 8. Excel Vlookup With Named Range: Advanced Method
10:14 9. How to Use Vlookup in Excel Tables
12:30 10. VLOOKUP Limitation
12:55 11. Alternative of VLOOKUP
13:21 12. Index and Match Function - Advanced VLOOKUP
15:25 13. Excel VLOOKUP Function Usage in Calculation
17:33 14. Two Way VLOOKUP or Auto Select Column Index Number in VLOOKUP

☕ If you found the videos useful and would like to support me, you can buy me a coffee –

Subscribe and Support me to Create more such videos

#msexcel #Vlookup #exceltraining
Рекомендации по теме
Комментарии
Автор

Really good video I like the way you explain, keep up the good work ☺️

sudevshan