Vlookup Data From Multiple Database
“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.