Spreadsheet: 165963d1341411433-how-do-i-look-up-value-that-may-be-in-one-of-many-columns-without-having-defined-ranges-sample-dashboard-data-pull
Sheet: Company

 |  |  |  |  |  |  | Oct 08 |  | Nov 08 |  | Dec 08 |  | Jan 09 |  | Feb 09 |  | Mar 09 |  | Apr 09
 |  | Income
 |  |  | 4000 · Revenue
 |  |  |  | 4100 · [NAME]
 |  |  |  |  | 4101 · Mechanical |  | 29.21428571428572 | 0 | 96.42857142857143 | 0 | 230.2042857142857 | 0 | 64.29285714285714 | 0 | 205.5342857142857 | 0 | 531.1271428571429 | 0 | 151.1214285714286
 |  |  |  |  | 4102 · Metal |  | 3944.915714285714 | 0 | 3819.684285714286 | 0 | 4477.070000000001 | 0 | 4895.741428571429 | 0 | 6393.115714285714 | 0 | 6018.334285714285 | 0 | 4531.462857142858
 |  |  |  |  | 4103 · Paint |  | 2731.717142857143 | 0 | 2596.555714285714 | 0 | 2894.588571428571 | 0 | 3338.815714285714 | 0 | 3813.065714285714 | 0 | 3671.424285714286 | 0 | 3241.224285714286
 |  |  |  |  | 4105 · Structural |  | 159.8571428571429 | 0 | 177.0128571428571 | 0 | 275.4528571428572 | 0 | 223.5214285714286 | 0 | 150.95 | 0 | 352.5414285714286 | 0 | 261.7142857142857
 |  |  |  |  | 4106 · [NAME] |  | 384.58 | 0 | 524.15 | 0 | 624.1628571428572 | 0 | 806.8100000000001 | 0 | 372.67 | 0 | 26.24857142857143 | 0 | 1.961428571428572
 |  |  |  |  | 4100 · Labour - Other |  | 12.85714285714286 | 0 | 0 | 0 | 0 | 0 | 5.828571428571428 | 0 | 9.657142857142857 | 0 | 0 | 0 | 22.28571428571428
 |  |  |  | Total 4100 · [NAME] |  |  | 7263.141428571428 | 0 | 7213.831428571429 | 0 | 8501.478571428572 | 0 | 9335.01 | 0 | 10944.99285714286 | 0 | 10599.67571428571 | 0 | 8209.77
 |  |  |  | 4300 · Parts |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 4301 · Aftermarket |  | 369.95 | 0 | 498.6885714285714 | 0 | 741.1828571428571 | 0 | 1192.712857142857 | 0 | 605.7585714285715 | 0 | 1131.824285714286 | 0 | 621.8685714285714
 |  |  |  |  | 4302 · New (OEM) |  | 2449.132857142857 | 0 | 5102.367142857142 | 0 | 7832.578571428572 | 0 | 5673.284285714285 | 0 | 5307.467142857143 | 0 | 5832.96 | 0 | 4293.059999999999
 |  |  |  |  | 4304 · Sublet |  | 547.2285714285714 | 0 | 385.7928571428571 | 0 | 1510.592857142857 | 0 | 959.5128571428571 | 0 | 904.3285714285714 | 0 | 1021.534285714286 | 0 | 2462.095714285714
 |  |  |  |  | 4305 · Used (LKQ) |  | 204.9914285714286 | 0 | 239.1428571428571 | 0 | 505.7142857142857 | 0 | 520.2857142857143 | 0 | 185.2857142857143 | 0 | 558.8571428571429 | 0 | 295.7142857142857
 |  |  |  | Total 4300 · Parts |  |  | 3571.302857142857 | 0 | 6225.991428571429 | 0 | 10590.06857142857 | 0 | 8345.795714285714 | 0 | 7002.839999999999 | 0 | 8545.175714285715 | 0 | 7672.738571428571
 |  |  |  | 4800 · Other Sales Income |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 4804 · Discounts - Insurance |  | 0 | 0 | -68.16857142857143 | 0 | -153.1628571428571 | 0 | -59.39285714285715 | 0 | -78.41285714285713 | 0 | -104.8957142857143 | 0 | -39.82142857142857
 |  |  |  | Total 4800 · Other Sales Income |  |  | 0 | 0 | -68.16857142857143 | 0 | -153.1628571428571 | 0 | -59.39285714285715 | 0 | -78.41285714285713 | 0 | -104.8957142857143 | 0 | -39.82142857142857
 |  |  |  | 4803 · Storage |  |  | 0 | 0 | 50 | 0 | 0 | 0 | 240 | 0 | 251.4285714285714 | 0 | 0 | 0 | 0
 |  |  | Total 4000 · Revenue |  |  |  | 12786.30285714286 | 0 | 16255.30428571429 | 0 | 21539.75142857143 | 0 | 20743.49285714286 | 0 | 21468.97714285714 | 0 | 22073.51428571429 | 0 | 18321.51857142857
 |  |  | 4940 · [NAME] |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 4941 · PST Compensation |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 63.02999999999999
 |  |  |  | 4999 · Uncategorized Income |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Total 4940 · Misc Income |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 63.02999999999999
 |  | Total Income |  |  |  |  | 12786.30285714286 | 0 | 16255.30428571429 | 0 | 21539.75142857143 | 0 | 20743.49285714286 | 0 | 21468.97714285714 | 0 | 22073.51428571429 | 0 | 18384.54857142857