Intro Price Lookup

This intro problem practices VLOOKUP. VLOOKUP searches for a value in the first column of a table and returns a matching value from another column in that same row. Update the output cells so each order shows the total cost by looking up the order item's price in the price lookup 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.

VLOOKUP
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50