Spreadsheet: 154400d1336413045-nested-if-or-with-vlookup-formula-w-and-d
Sheet: Sheet1

 |  |  |  | [NAME] | 2.55 |  |  |  |  | P Length | Cable | Weight
 |  |  |  | HTx [NAME] | 1.4 |  |  |  |  | 6 | 10 | 2.5 |  | Cable Length | Weight | Diff
 |  |  |  |  |  |  |  |  |  | 8 | 10 | 2.6 |  | 10ft Cable | 0.65 | +0
Add 8 Inches to P Length to get [NAME] |  |  |  |  |  |  |  | Pallet Size | Weight | 10 | 10 | 2.8 |  | 15ft Cable | 0.95 | +0.3
ITEM # | Probe Length | Cable Length | [NAME] | Weight | # of Probes | Total Weight |  | 120x48 | 113 | 12 | 10 | 2.9 |  | 20ft Cable | 1.25 | +0.6
1 | 6 | 10 | 14 | 2.5 | 2 | 5 |  | 144x48 | 155 | 13 | 10 | 2.9 |  | 25ft Cable | 1.58 | +0.93
2 | 12 | 10 | 20 | 2.9 | 1 | 2.6 |  | 120x32 |  | 14 | 10 | 3.1 |  | 30ft Cable | 1.9 | +1.25
3 | 41 | 10 | 49 | 5.1 |  |  |  | 144x32 |  | 16 | 10 | 3.2 |  | 40ft Cable | 2.5 | +1.85
4 | 41 | 20 | 49 | 5.1 |  |  |  | 96x48 |  | 17 | 10 | 3.3 |  | 50ft Cable | 3.1 | +2.45
5 |  |  |  | #N/A |  |  |  | 72x48 |  | 18 | 10 | 3.7
6 |  |  |  | #N/A |  |  |  | 96x32 |  | 19 | 10 | 3.8
7 |  |  |  | #N/A |  |  |  |  |  | 20 | 10 | 3.9
8 |  |  |  | #N/A |  |  |  |  |  | 22 | 10 | 4
9 |  |  |  | #N/A |  |  |  |  |  | 24 | 10 | 4.1
10 |  |  |  | #N/A |  |  |  |  |  | 25 | 10 | 4.1
11 |  |  |  | #N/A |  |  |  |  |  | 26 | 10 | 4.2
12 |  |  |  | #N/A |  |  |  |  |  | 27 | 10 | 4.3
13 |  |  |  | #N/A |  |  |  |  |  | 28 | 10 | 4.3
14 |  |  |  | #N/A |  |  |  |  |  | 30 | 10 | 4.4
15 |  |  |  | #N/A |  |  |  |  |  | 31 | 10 | 4.5
16 |  |  |  | #N/A |  |  |  |  |  | 32 | 10 | 4.6
17 |  |  |  | #N/A |  |  |  |  |  | 35 | 10 | 4.8
18 |  |  |  | #N/A |  |  |  |  |  | 36 | 10 | 4.8
19 |  |  |  | #N/A |  |  |  |  |  | 38 | 10 | 4.9
20 |  |  |  | #N/A |  |  |  |  |  | 40 | 10 | 5
21 |  |  |  | #N/A |  |  |  |  |  | 41 | 10 | 5.1
22 |  |  |  | #N/A |  |  |  |  |  | 42 | 10 | 5.2
23 |  |  |  | #N/A |  |  |  |  |  | 44 | 10 | 5.3
24 |  |  |  | #N/A |  |  |  |  |  | 45 | 10 | 5.4
25 |  |  |  | #N/A |  |  |  |  |  | 46 | 10 | 5.5
26 |  |  |  | #N/A |  |  |  |  |  | 48 | 10 | 5.7
27 |  |  |  | #N/A |  |  |  |  |  | 50 | 10 | 5.8
28 |  |  |  | #N/A |  |  |  |  |  | 52 | 10 | 5.9
29 |  |  |  | #N/A |  |  |  |  |  | 54 | 10 | 6
30 |  |  |  | #N/A |  |  |  |  |  | 55 | 10 | 6.1
31 |  |  |  | #N/A |  |  |  |  |  | 56 | 10 | 6.1
32 |  |  |  | #N/A |  |  |  |  |  | 57 | 10 | 6.2
33 |  |  |  | #N/A |  |  |  |  |  | 58 | 10 | 6.3
34 |  |  |  | #N/A |  |  |  |  |  | 60 | 10 | 6.4
35 |  |  |  | #N/A |  |  |  |  |  | 62 | 10 | 6.5
36 |  |  |  | #N/A |  |  |  |  |  | 63 | 10 | 6.5
37 |  |  |  | #N/A |  |  |  |  |  | 64 | 10 | 6.6
38 |  |  |  | #N/A |  |  |  |  |  | 67 | 10 | 6.8
39 |  |  |  | #N/A |  |  |  |  |  | 72 | 10 | 7
40 |  |  |  | #N/A |  |  |  |  |  | 74 | 10 | 7.3
41 |  |  |  | #N/A |  |  |  |  |  | 77 | 10 | 7.6
42 |  |  |  |  |  |  |  |  |  | 79 | 10 | 7.8
43 |  |  |  |  |  |  |  |  |  | 80 | 10 | 7.8
44 |  |  |  |  |  |  |  |  |  | 84 | 10 | 8.1
45 |  |  |  |  |  |  |  |  |  | 85 | 10 | 8.2
46 |  |  |  |  |  |  |  |  |  | 90 | 10 | 8.5
 |  |  |  |  |  |  |  |  |  | 92 | 10 | 8.6
 |  |  |  |  |  |  |  |  |  | 95 | 10 | 8.7
 |  |  |  |  |  |  |  |  |  | 96 | 10 | 8.8
 |  |  |  |  |  |  |  |  |  | 100 | 10 | 9
 |  |  |  |  |  |  |  |  |  | 108 | 10 | 9.6
 |  |  |  |  |  |  |  |  |  | 112 | 10 | 9.8
 |  |  |  |  |  |  |  |  |  | 120 | 10 | 11.1
 |  |  |  |  |  |  |  |  |  | 132 | 10 | 12.1