“Lookup or compare the values of an item across multiple tables. Like in this example I have tried to find out the lowest price of a product from a list of 3 product catalogues of 3 online sellers. T the his method can be used to lookup data for upto 254 tables !
To lookup data from multiple tables I have used the vlookup formula with the choose formula and incase you would like to learn the vlookup and Choose formula then you can refer these links
Vlookup Formula Link – http://www.youtube.com/watch?v=igSioxmHzLI
Choose Formula link – https://www.youtube.com/watch?v=p7l6vxdT5Mg
Vlookup formula in Hindi can be uised to lookup data and i have a made a list of 15 videos on Vlookup in Excel in hindi
Use Vlookup In Excel Hindi
http://www.myelesson.org/excel-training-videos/vlookup-formula-in-excel-2013/
Vlookup The Highest Value
http://www.myelesson.org/excel-training-videos/vlookup-with-max-formula-hindi/
Vlookup Formula with Min Formula
http://www.myelesson.org/excel-training-videos/vlookup-with-min-formula-hindi/
Vlookup Data in Hindi
http://www.myelesson.org/excel-training-videos/vlookup-from-different-sheets-hindi/
Use Vlookup Formula In Excel
http://www.myelesson.org/excel-training-videos/vlook-up-hindi/
Vlookup Better Than Lookup Formula
Vlookup Data From Multiple Database
Vlookup Exact Approx Match
http://www.myelesson.org/excel-training-videos/vlookup-exact-approx-match-hindi/
Vlookup Multiple Results At Once
http://www.myelesson.org/excel-training-videos/vlookup-multiple-results-at-once-hindi/
Remove NA Error From VLOOKUP
http://www.myelesson.org/excel-training-videos/remove-the-na-error-from-vlookup-excel-hindi/
Vlookup Formula and Mid Formula
http://www.myelesson.org/excel-training-videos/vlookup-with-mid-formula/
6 Examples of Vlookup
http://www.myelesson.org/excel-training-videos/6-examples-of-vlookup/
Vlookup with Dropdown List
http://www.myelesson.org/excel-training-videos/vlookup-with-droplown-list/
Macro for Vlookup
http://www.myelesson.org/excel-training-videos/macro-for-vlookup/
Vlookup Item In Multiple Lists
http://www.myelesson.org/excel-training-videos/Vlookup-item-in-multiple-lists/
“