Pricing Information for Frozen Beef Grassland Markets VLOOKUP 1 st variable is what you need to use as a reference in this case, it is the quantity to determine the unit price, 2nd variable is the matrix or table where the information is stored In this case it is in the cells at the top for unit pricing. Note: The first column to the left in the table is the lookup that matches with the first variable, eg you are looking up the quantity so the table has to start with the "A" column. YOU MUST USE AN ABSOLUTE REFERENCE 3rd variable is the column where the information will be retrieved in this case the column with price each. 4th variable is either TRUE or FALSE You use FAL SE if the match is exact, eg it will only return an answer if the number listed in the quantity column is the same as that listed in the reference table IRUE is used when you want it to look into the table and relurn the last value that was at or less then your reference number. HLOOKUP. The primary difference is that now you are looking up rows instead of columns. For this exercise you are looking for an exact match (FALSE). The discount is also a negative number so you want a =HLOOKUP(XXX) Use SHIPPING DISCOUNT 2 Use the following spreadsheet to complete this assignment Vlookup and Hlookup Project Beef - Student Copy,xlsx You should complete the following requirements: - Use a VLookup to complete the following columns: - Unit Price - Unit Shipping - Use an HLookup to complete the Shipping Discount column (this should be a dollar amount, so need to use an HLookup to find the percentage, then multiply by the total shipping) - Use cell references to complete the following columns: - Total Price - Total Shipping - Grand Total - Complete the Total row at the bottom of the table for the Grand Total column only Nothing should be hard-coded