Can someone help me with questions 1A and 1B? See attachment FIN 615 VLOOKUP Problem 1 Fresh
Fantastic news! We've Found the answer you've been seeking!
Question:
Can someone help me with questions 1A and 1B? See attachment
FIN 615 VLOOKUP Problem 1 Fresh Blooms, LLC is a floral wholesaler. You want to create an invoice template that references the list of products available using the VLOOKUP function. Copy the invoice template below into a new workbook and populate the highlighted cells with a VLOOKUP function referencing the product table. Hint: you will need to use an IF logical test . Code Product A23 B14 A27 C45 Tulips Roses Carnations House plants Price 10.00 15.00 5.00 12.00 Invoice Template Invoice # Date Code 74632 1/14/2010 Product Unit Cost A23 A27 B14 C45 Quantity 3 2 1 4 Subtotal Tax Total 10% Total $ $ $ $ $ $ $ - $ $ $ - FIN 615 Problem 1 Below is select sales data for RX Industries. The orders range from 1 to 20, however any returned or canceled orders have been deleted from the data. Use the template below to create an order summary that automatically shows the data for any selected order ID between 1 and 20. Hint: Use the IFERROR and HLOOKUP functions. The function for any order ID in the range that has been deleted should return the phrase "Not Found." 1 7 9 13 16 2 3 5 10 14 4 8 11 17 18 OrderID West West West West West Central Central Central Central Central Region East East East East East OrderDate 1/10/2009 3/6/2009 3/28/2009 4/8/2009 4/12/2009 5/16/2009 5/23/2009 6/2/2009 7/8/2009 7/30/2009 8/29/2009 9/9/2009 10/5/2009 11/16/2009 12/25/2009 OrderAmt $ 1,122.00 $ 4,453.00 $ 1,305.00 $ 2,708.00 $ 1,502.00 $ 4,796.00 $ 1,526.00 $ 1,523.00 $ 2,068.00 $ 1,597.00 $ 781.00 $ 2,976.00 $ 4,145.00 $ 3,979.00 $ 2,044.00 View Current Orders From All Regions Select an Order ID to see its details OrderID 7 20 Region OrderDate OrderAmt
Posted Date: