Spreadsheet: 390212d1429549809-solved-post-a-value-in-a-cell-based-off-the-value-of-an-index-cell-example_book1
Sheet: Sheet1

date/time | [NAME] | quantity | product sales | sales tax collected | shipping | packing | other transaction fees | other | total | Cost
Jan 9, 2015 6:33:34 PM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 9, 2015 6:58:24 PM PST | 252123 | 1 | 10 | 0.75 | -1.5 | -2.97 | -0.02 | 0 | 6.26
Jan 12, 2015 10:44:35 PM PST | 252123 | 1 | 10 | 0 | -3 | -2.97 | 0 | 0 | 4.03
Jan 12, 2015 10:44:35 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 12, 2015 11:04:38 AM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 12, 2015 2:21:57 AM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 12, 2015 4:58:31 AM PST | 252123 | 1 | 10 | 0.81 | -4.5 | -1.97 | -0.07 | 0 | 4.27
Jan 12, 2015 4:58:31 AM PST | 252123 | 1 | 10 | 0.81 | 0 | -1.97 | 0 | 0 | 8.84
Jan 12, 2015 4:58:31 AM PST | 252123 | 1 | 10 | 0.81 | 0 | -2.97 | 0 | 0 | 7.84
Jan 12, 2015 6:22:15 PM PST | 252123 | 1 | 10 | 0 | -4.5 | -1.97 | 0 | 0 | 3.53
Jan 12, 2015 6:22:15 PM PST | 252123 | 1 | 10 | 0 | 0 | -2.97 | 0 | 0 | 7.03
Jan 12, 2015 6:22:15 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 13, 2015 12:11:23 AM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 14, 2015 12:25:58 AM PST | 252123 | 1 | 10 | 0 | -4.5 | -1.97 | 0 | 0 | 3.53
Jan 14, 2015 12:25:58 AM PST | 252123 | 1 | 10 | 0 | 0 | -2.97 | 0 | 0 | 7.03
Jan 14, 2015 12:25:58 AM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 3:45:44 PM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | -15 | -1.97 | 0 | 0 | -6.97
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -2.97 | 0 | 0 | 7.03
Jan 14, 2015 5:26:28 PM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 14, 2015 8:17:36 PM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 15, 2015 1:15:22 AM PST | 252123 | 1 | 10 | 0 | -3 | -2.97 | 0 | 0 | 4.03
Jan 15, 2015 1:15:22 AM PST | 252123 | 1 | 10 | 0 | 0 | -1.97 | 0 | 0 | 8.03
Jan 15, 2015 1:34:30 AM PST | 252123 | 1 | 10 | 0 | -1.5 | -8.45 | 0 | 0 | 5.53
Jan 15, 2015 2:25:06 PM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 15, 2015 4:31:45 PM PST | 252123 | 1 | 10 | 0 | -1.5 | -2.97 | 0 | 0 | 5.53
Jan 15, 2015 3:02:09 AM PST | 10-421RED | 10 | 58.7 | 4.8 | -15 | -15.7 | -0.21 | 0 | 32.59
Jan 15, 2015 3:02:09 AM PST | 10-421RED | 5 | 29.35 | 2.4 | 0 | -8.85 | 0 | 0 | 22.9
Jan 15, 2015 5:40:17 PM PST | 10-421RED | 1 | 5.87 | 0 | -1 | -2.57 | 0 | 0 | 2.3
Jan 10, 2015 2:01:08 PM PST | 10076-PPA | 2 | 22.8 | 0 | -2.74 | -16.73 | 0 | 0 | 15.92
Jan 12, 2015 9:14:41 PM PST | 10076-PPA | 1 | 11.4 | 0 | -1.37 | -2.57 | 0 | 0 | 7.46
Jan 14, 2015 6:41:22 PM PST | 10076-PPA | 2 | 22.8 | 0 | -6.84 | -4.14 | 0 | 0 | 11.82
Jan 14, 2015 6:41:22 PM PST | 10076-PPA | 3 | 34.2 | 0 | 0 | -4.71 | 0 | 0 | 29.49
Jan 15, 2015 7:25:30 PM PST | 10076-PPA | 1 | 11.4 | 0 | -1.37 | -6.56 | 0 | 0 | 7.46
Jan 9, 2015 7:05:38 PM PST | 10077-PPS | 2 | 25 | 0 | -6 | -3.14 | 0 | 0 | 15.86
Jan 9, 2015 7:05:38 PM PST | 10077-PPS | 1 | 12.5 | 0 | 0 | -1.57 | 0 | 0 | 10.93
Jan 9, 2015 7:05:38 PM PST | 10077-PPS | 1 | 12.5 | 0 | 0 | -2.57 | 0 | 0 | 9.93
Jan 10, 2015 9:52:18 PM PST | 10077-PPS | 1 | 12.5 | 0.94 | -1.5 | -2.57 | -0.03 | 0 | 9.34
Jan 9, 2015 10:12:27 PM PST | [PHONE] | 1 | 48 | 0 | -7.2 | -17.78 | 0 | 0 | 38.23
Jan 9, 2015 10:22:40 PM PST | [PHONE] | 1 | 48.12 | 3.61 | -7.22 | -2.57 | -0.1 | 0 | 41.84
Jan 9, 2015 4:28:56 PM PST | [PHONE] | 1 | 48.42 | 0 | -7.26 | -2.57 | 0 | 0 | 38.59
Jan 9, 2015 7:13:41 PM PST | [PHONE] | 1 | 48.32 | 0 | -7.25 | -2.57 | 0 | 0 | 38.5
Jan 10, 2015 1:04:40 PM PST | [PHONE] | 1 | 48.84 | 0 | -7.33 | -2.57 | 0 | 0 | 38.94
Jan 10, 2015 1:05:57 PM PST | [PHONE] | 1 | 48.12 | 0 | -7.22 | -2.57 | 0 | 0 | 38.33
Jan 10, 2015 1:21:43 AM PST | [PHONE] | 1 | 45.44 | 0 | -6.82 | -2.57 | 0 | 0 | 36.05
Jan 15, 2015 9:04:11 AM PST | [PHONE] | 1 | 53.72 | 0 | -8.06 | -6.56 | 0 | 0 | 43.09
Jan 10, 2015 11:37:05 AM PST | [PHONE] | 1 | 53.84 | 0 | -8.08 | -2.57 | 0 | 0 | 43.19
Jan 11, 2015 5:30:52 PM PST | [PHONE] | 1 | 52.94 | 0 | -7.94 | -2.57 | 0 | 0 | 42.43
Jan 13, 2015 5:47:58 PM PST | [PHONE] | 1 | 51.28 | 0 | -7.69 | -2.57 | 0 | 0 | 41.02
Jan 14, 2015 3:14:37 PM PST | [PHONE] | 1 | 51.1 | 0 | -7.67 | -2.57 | 0 | 0 | 40.86
Jan 10, 2015 3:08:06 PM PST | 1301-FAE-0103 | 1 | 100.27 | 0 | -12.03 | -5.31 | 0 | 0 | 82.93
Jan 10, 2015 4:43:14 AM PST | 221-002-08 | 1 | 34.53 | 2.8 | -4.14 | -7.75 | -0.08 | 0 | 30.54
Jan 10, 2015 4:33:02 PM PST | 221-002-10 | 1 | 34.95 | 0 | -5.24 | -2.57 | 0 | 0 | 27.14
Jan 12, 2015 9:20:38 AM PST | 2343 | 1 | 21.99 | 1.65 | -3.3 | -9.59 | -0.05 | 0 | 17.72
Jan 13, 2015 12:35:16 PM PST | 252153-5 | 1 | 12 | 0 | -1.44 | -2.57 | 0 | 0 | 7.99
Jan 9, 2015 9:49:57 PM PST | 321298 | 2 | 160 | 0 | -19.2 | -5.5 | 0 | 0 | 135.3
Jan 10, 2015 1:42:04 AM PST | 321298 | 1 | 80 | 0 | -9.6 | -3.75 | 0 | 0 | 66.65
Jan 12, 2015 1:27:18 PM PST | 321298 | 1 | 80 | 0 | -9.6 | -3.75 | 0 | 0 | 66.65
Jan 12, 2015 10:03:03 AM PST | 321298 | 1 | 80 | 6 | -9.6 | -3.75 | -0.17 | 0 | 72.48
Jan 12, 2015 11:39:22 AM PST | 321298 | 1 | 80 | 0 | -9.6 | -3.75 | 0 | 0 | 66.65 | 66.65
Jan 12, 2015 2:10:51 AM PST | 321298 | 1 | 80 | 0 | -9.6 | -3.75 | 0 | 0 | 66.65 | 66.65
Jan 12, 2015 2:47:30 AM PST | 321298 | 1 | 80 | 6.48 | -9.6 | -3.75 | -0.19 | 0 | 72.94
Jan 13, 2015 7:23:30 PM PST | 321298 | 1 | 80 | 0 | -9.6 | -3.75 | 0 | 0 | 66.65
Jan 14, 2015 11:39:37 AM PST | 321298 | 1 | 80 | 0 | -9.6 | -10.8 | 0 | 0 | 66.65