Free Excel training videos

Data analysis and Vlookup

Let's use data analysis and Vlookup today to solve a real world problem from the sales data of an electronics store. We have here the data of the sales of different products by different sales people. Now we wish to extract information like which sales persons sold how many iPads or Televisions (TV). As you can see we have extracted the information of sales by Vicky using Vlookup. The use of 'FALSE' is based on the fact that the spreadsheet data has not been sorted in any order.
Watch the Excel training video below to see how data analysis with Vlookup is implemented:








Further reading on Vlookup


Data analysis and Vlookup