Vlookup formula in MS Excel is very good at looking up date from a data base but thats is also the problem with it, that it can lookup data from only one database . Not anymore ..\r
\r
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.\r
\r
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. \r
Now to define the database to lookup I have used the Choose formula , which allows me to define 3 databases to lookup from.\r
\r
You can download the file shown in the video from \r
\r
To watch more videos and download the files visit
