newboy2020
New Member
- Joined
- Dec 9, 2020
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
I am trying to figure out if there is a formula or a double vlook up forumla which can quickly calculate the results I have manually input in Cells C2,C3,C4 using the values from Columns G,H,I
Sum_Test.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | # of Cartons | # of Pallets | Price | # of Cartons | # of Pallets | Price | |||||
2 | 3 | 13 | $ 1,630.00 | 2 | 1 | 265 | |||||
3 | 2 | 5 | $ 480.00 | 2 | 2 | 325 | |||||
4 | 3 | 16 | $ 2,630.00 | 2 | 3 | 380 | |||||
5 | 3 | 8 | 2 | 4 | 435 | ||||||
6 | 3 | 17 | 2 | 5 | 480 | ||||||
7 | 3 | 7 | 2 | 6 | 525 | ||||||
8 | 2 | 18 | 2 | 7 | 570 | ||||||
9 | 2 | 6 | 2 | 8 | 615 | ||||||
10 | 3 | 8 | 2 | 9 | 660 | ||||||
11 | 3 | 15 | 2 | 10 | 705 | ||||||
12 | 4 | 9 | 6 | 1 | 750 | ||||||
13 | 3 | 7 | 6 | 52 | 795 | ||||||
14 | 2 | 6 | 2 | 13 | 840 | ||||||
15 | 2 | 4 | 2 | 14 | 885 | ||||||
16 | 2 | 9 | 2 | 15 | 930 | ||||||
17 | 2 | 11 | 2 | 16 | 1030 | ||||||
18 | 2 | 12 | 2 | 17 | 1130 | ||||||
19 | 2 | 5 | 2 | 18 | 1230 | ||||||
20 | 2 | 20 | 2 | 19 | 1330 | ||||||
21 | 3 | 13 | 2 | 20 | 1430 | ||||||
22 | 2 | 20 | 2 | 21 | 1530 | ||||||
23 | 2 | 12 | 3 | 13 | 1630 | ||||||
24 | 2 | 10 | 12 | 1 | 1730 | ||||||
25 | 3 | 52 | 2 | 24 | 1830 | ||||||
26 | 6 | 52 | 2 | 25 | 1930 | ||||||
27 | 6 | 1 | 2 | 26 | 2030 | ||||||
28 | 12 | 1 | 2 | 27 | 2130 | ||||||
29 | 1 | Multiple | 2 | 28 | 2230 | ||||||
30 | 3 | 10 | 3 | 10 | 2330 | ||||||
31 | 3 | 10 | 3 | 15 | 2430 | ||||||
32 | 6 | 12 | 3 | 8 | 2530 | ||||||
33 | 3 | 16 | 2630 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I17:I33 | I17 | =I16+100 |