Take any TWO different data ranges and use VLOOKUP to come up with a useful way to pull the information together. For example, if you have a price list and an order list (in separate locations), you may want to use VLOOKUP to determine how much an order costs (quantity x price). Use VLOOKUP to pull all of the information onto one excel sheet. Complete each of the following:

1-Show two separate accounting related data points

2-Effectively use VLOOKUP to pull information in one location in order to achieve a particular accounting objective (i.e. Total cost for an order)

3-State your accounting objective and how VLOOKUP helped you solve for the objective quicker and more effectively that doing it manually.

4- You must apply VLOOKUP on at least 10 lines of data.