In the given spreadsheet, columns A though E represent a data table. However, there are missing values in columns C through E. In cell J1 there is a lookup table containing columns for Product, Product ID, and Unit Price. Your first task is to fill in the missing values in columns. C, D, and E using VLookup and the lookup table Doing this manually would take a long time and be very tedious. The best way is to use VLOOKUP to fill in the first row of missing data and then drag down to fill the remaining rows. In cell C2, populate the Product ID of the first item using VioOKup. The value you wish to look up in the lookup table is in Column A, cell Az to be exact. The lookup table is cell range $ I\$1:\$1 \$6. Note that these are absolute cell references since the look up table is in a fixed location. The Product ID is in the second column of the lookup table. And finally set the range_lookup parameter to FALSE. What is the Product 10 returned in cell c2? Now repeat this process for the missing Unit Price in cell 02 . What is the unit price returned in D2 (to-the nearest cent)? And finally, for the first item, calculate the Gross Sales in column E using Order Quantity from column B and Unit Price from Column D. What is the gross sale amiotant in cell E2? To complete the data table, select celis C2,D2, and E2 together then drag down or double-click the fill + sign in the lower right of thase three selected ceilk, And there you have it. The remaining 147 iterns in columns C, D, and E have been completed usang a lookup table, two VLookuP formulas, a simple math formula, and Excel's fil down feature. Combining viookup with a Pivot Table Now that you have the data tatle in columns A through E, a Pivot Table can be used to summarize the data on a number of factors