Vlookup 3 Data Tables At Once Hindi

Vlookup 3 Data Tables At Once Hindi

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 ..\rbr\rbrIn 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.\rbr\rbrThe 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. \rbrNow to define the database to lookup I have used the Choose formula , which allows me to define 3 databases to lookup from.


User: Sazar

Views: 1

Uploaded: 2017-09-15

Duration: 06:47