Question

	A	B	C	D	E	F	H
1	Header
2	Subheader
3		Ingredient
4	Project	Alpha	Bravo Two	Charlie	Delta
5	A		0.2		0.4	2	2
6	B	0.2				0.2
7	C		0.3	0.3		1.5
8	D	0.5			0.4	2.1
9
10	I want a result here that takes everything in Project A, multiplies the value under each Ingredient, then takes that column's Ingredient name, goes to the table in Sheet 2, looks up that name, and then vlookup the Cost value, multiply that, and then sum the product (basically the total cost of Project A)
11
12	So, Project A is (0x1)+(0.2x2)+(0x3)+(0.4x4)=2
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100