Vlookup and Data Validation tools in Excel

This video will show how to use the Vlookup function and Data Validation tool to pick up data from a sheet and display the data in a particular row. I have also shown auto-sum and Percentage calculations for the given data. And also a trick where you need not enter the Vlookup again and simply drag to obtain data from adjacent columns.