|
|
|
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 computers and printers. As you can see we have
extracted the information of sales by Wendy and Harry in slightly two
different forms using Vlookup. The use of 'FALSE' is based on the fact
that the spreadsheet data has not been sorted in ascending order. Also
note the interesting use of numbering the columns of the products to
make the data easily accessible in the formula.
|
|
|
|
|
|
|
|
|
|
|
|
|