Spreadsheet: 56655d1256789246-using-two-lookup-values-in-one-formula-grapeharvestoct-28test
Sheet: Value and Tonnes 2010-2015

 |  |  |  |  | Projected Tonnes
Type | Variety | Acres | 2010 | 2011 | 2012 | 2013 | 2014
Red | Merlot | 77.27048176104961 | 98.65183237761393 | 104.2310201023123 | 104.2310201023123 | 104.2310201023123 | 104.2310201023123
Red | [NAME] | 3.9292468630192 | 15.16813313121252 | 15.16813313121252 | 15.16813313121252 | 15.16813313121252 | 15.16813313121252
Red | Pinot Noir | 37.9838168453967 | 45.27760314466607 | 61.53435827094168 | 68.03207080397455 | 68.03207080397455 | 68.03207080397455
Red | Petite Verdot | 5.3199937915859 | 10.3351050656303 | 10.3351050656303 | 10.3351050656303 | 10.3351050656303 | 10.3351050656303
Red | Malbec | 14.4021644478885 | 20.05105637156846 | 20.05105637156846 | 20.05105637156846 | 20.05105637156846 | 20.05105637156846
Red | [NAME] | 3.44 | 14.47867253433922 | 14.47867253433922 | 14.47867253433922 | 14.47867253433922 | 14.47867253433922
White | Pinot Gris | 39.312973295204 | 112.1643528913347 | 127.4812643618725 | 127.4812643618725 | 127.4812643618725 | 127.4812643618725
White | Gewurztraminer | 16.3 | 74.51617556206915 | 91.73817552396739 | 91.73817552396739 | 91.73817552396739 | 91.73817552396739
White | Chardonnay | 46.0758512837164 | 101.3307496704651 | 119.899012166258 | 119.899012166258 | 119.899012166258 | 119.899012166258
White | Sauv. Blanc | 0 | 0 | 0 | 0 | 0 | 0
White | Pinot Blanc | 18.945761616622 | 19.14160341319283 | 26.03258064194225 | 26.03258064194225 | 26.03258064194225 | 26.03258064194225
White | Riesling | 39.2346393363848 | 20.32094390784452 | 20.32094390784452 | 20.32094390784452 | 20.32094390784452 | 20.32094390784452
White | Schoenburger | 5.85 | 26.53516112966304 | 26.53516112966304 | 26.53516112966304 | 26.53516112966304 | 26.53516112966304
 | COMBINED TOTAL |  | 557.9713891995997 | 637.805483207552 | 644.3031957405849 | 644.3031957405849 | 644.3031957405849
 | Red Total: | 142.3457037089399 | 203.9624026250305 | 225.7983454760045 | 232.2960580090373 | 232.2960580090373 | 232.2960580090373
 | White Total: | 165.7192255319272 | 354.0089865745693 | 412.0071377315476 | 412.0071377315476 | 412.0071377315476 | 412.0071377315476
 |  |  | Projected  $
Type | Variety | Acres | 2010 | 2011 | 2012 | 2013 | 2014
Red | Merlot | 77.27048176104961 | #N/A | #N/A | #N/A | #N/A | #N/A
Red | [NAME] | 3.9292468630192 | #N/A | #N/A | #N/A | #N/A | #N/A
Red | Pinot Noir | 37.9838168453967 | #N/A | #N/A | #N/A | #N/A | #N/A
Red | Petite Verdot | 5.3199937915859 | #N/A | #N/A | #N/A | #N/A | #N/A
Red | Malbec | 14.4021644478885 | #N/A | #N/A | #N/A | #N/A | #N/A
Red | [NAME] | 3.44 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954
White | Pinot Gris | 39.312973295204 | #N/A | #N/A | #N/A | #N/A | #N/A
White | Gewurztraminer | 16.3 | #N/A | #N/A | #N/A | #N/A | #N/A
White | Chardonnay | 46.0758512837164 | #N/A | #N/A | #N/A | #N/A | #N/A
White | Sauv. Blanc | 0 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954
White | Pinot Blanc | 18.945761616622 | #N/A | #N/A | #N/A | #N/A | #N/A
White | Riesling | 39.2346393363848 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954
White | Schoenburger | 5.85 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954 | 29681.2786953954
 | COMBINED TOTAL |  | #N/A | #N/A | #N/A | #N/A | #N/A
 | Red Total: | 142.3457037089399 | #N/A | #N/A | #N/A | #N/A | #N/A
 | White Total: | 165.7192255319272 | #N/A | #N/A | #N/A | #N/A | #N/A