How to Use Vlookup Formula to lookup Data From Multiple Databases
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.