Look Who it Was Random video

Learn MS Excel - Vlookup Data From 3 Tables At Once English

4,606 views · Published 30 July 2013 · 4:49 · Indexed 23 September 2026

Channel: My E-Lesson · 2013 · Education

Watch on YouTube

Vlookup formula in MS Excel is very good at looking up date from a data base but that's is also the problem with it, that it can lookup data from only one database . Not anymore ....

In this video I have explained how to use Vlookup Formula to lookup data from 3 different databases by combining the Choose formula and the Vlookup Formula.

The Vlookup training video shows the example of looking airfares from 3 different airlines .  In an Vlookup formula we need to define 1. What to lookup, 2 the database from where to lookup , 3, the position of column in the database from where we do the lookup. 
Now to define the database to lookup I have used the Choose formula , which allows me to define 3 databases to lookup from.

You can download the file shown in the video from http://www.myelesson.org/excel-training-videos/ms-excel-vlookup-data-from-mutiple-databases-at-once-english/

To watch more videos and download the files visit http://www.myelesson.org 10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8HEBNAk

Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv3s8TuA

10 Most Used Excel Formula 
https://www.youtube.com/watch?v=2t3FDi98GBk
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomClevScJQ

5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4AMdij8

Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93-fQlCs

Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV9T1PoI

Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2UdajrDMjRE

How to Create Dashboard in Excel 
https://www.youtube.com/watch?v=RM8T1eYBjQY

Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1If63nGU

More from this channel