|
|
|
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:
|
|
|
|
|
|
|
|
|
|
|
|
|