This intro problem practices HLOOKUP. HLOOKUP searches for a value in the first row of a table and returns a matching value from another row in that same column. Update the output cells so each order shows the total cost by looking up the order item's price in the price table and multiplying it by the order quantity.
See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
Need help with HLOOKUP details and syntax? Review the HLOOKUP function guide first.
This cell cannot be edited