Spreadsheet: 50758d1250238900-vlookup-with-multiple-conditions-formula-find-example
Sheet: Base Data

 |  |  | Year
Product Class | Colour | Data | 2005 | 2006 | 2007 | 2008 | 2009 | Grand Total
Cups | Black | Quantity Sold | 1000 |  | 2000 | 3000 |  | 6000
 |  | Net Sales Value | 6000 |  | 12000 | 18000 |  | 36000
 | Red | Quantity Sold | 3000 | 4000 | 5000 | 6000 | 7000 | 25000
 |  | Net Sales Value | 12000 | 16000 | 20000 | 24000 | 28000 | 100000
 | Blue | Quantity Sold | 2000 | 3000 | 4000 | 5000 | 6000 | 20000
 |  | Net Sales Value | 3500 | 7000 | 11500 | 15000 | 18500 | 55500
 | Yellow | Quantity Sold |  |  |  | -2000 |  | -2000
 |  | Net Sales Value |  |  |  | -500 |  | -500
 | Green | Quantity Sold | 4000 | 5000 | 6000 | 7000 | 8000 | 30000
 |  | Net Sales Value | 16000 | 20000 | 24000 | 28000 | 32000 | 120000
Cups Quantity Sold |  |  | 10000 | 12000 | 17000 | 19000 | 21000 | 79000
Cups Net Sales Value |  |  | 37500 | 43000 | 67500 | 84500 | 78500 | 311000
Bowls | Black | Quantity Sold |  |  | 72000 |  |  | 72000
 |  | Net Sales Value |  |  | 14976 |  |  | 14976
 | Red | Quantity Sold | 66575 | 45325 |  |  |  | 111900
 |  | Net Sales Value | 17468.5 | 13265.53 |  |  |  | 30734.03
 | Blue | Quantity Sold | 211321 | 74252 | 10100 | 678575 | 281535 | 1255783
 |  | Net Sales Value | 36879.63 | 15745.42 | 1644.7 | 176903.4 | 91173.5 | 322346.65
 | Yellow | Quantity Sold | 1592599 | 498000 | 715000 | 727000 |  | 3532599
 |  | Net Sales Value | 347007 | 117600 | 170448 | 198219 |  | 833274
 | Green | Quantity Sold | 804650 | 602650 | 760250 | 957450 | 183475 | 3308475
 |  | Net Sales Value | 202449.98 | 167647.84 | 203263.73 | 265167.51 | 66716.54 | 905245.6000000001
Bowls Quantity Sold |  |  | 2675145 | 1220227 | 1557350 | 2363025 | 465010 | 8280757
[NAME] |  |  | 603805.11 | 314258.79 | 390332.4300000001 | 640289.91 | 157890.04 | 2106576.28
Small Plates | Black | Quantity Sold |  |  |  |  |  | 0
 |  | Net Sales Value |  |  |  |  |  | 0
 | Blue | Quantity Sold | 2943 | 1612 | 1074 | 2022 | 192 | 7843
 |  | Net Sales Value | 15415.09 | 9608.8 | 6524.22 | 12886.52 | 1332.48 | 45767.11000000001
 | Green | Quantity Sold | 5959 | 10353 | 9227 | 8280 | 2184 | 36003
 |  | Net Sales Value | 33390.65 | 60393.66 | 57163.16 | 52246.8 | 15262.8 | 218457.07
Small Plates Quantity Sold |  |  | 3488697 | 1834842 | 2327901 | 3330777 | 650861 | 11633078
Small Plates Net Sales Value |  |  | 855060.83 | 551909.09 | 657283.54 | 970590.7400000001 | 241201.86 | 3276046.06
Large Plates | Black | Quantity Sold | 687986 | 66408 |  | 23700 | 28400 | 806494
 |  | Net Sales Value | 179578.75 | 20209.7 |  | 0 | 12542.48 | 212330.93
 | Yellow | Quantity Sold |  | 25000 | -25000 | 327719 | 68564 | 396283
 |  | Net Sales Value |  | 0 | 0 | 140348.38 | 28843.51 | 169191.89
 | Green | Quantity Sold |  |  |  |  |  | 0
 |  | Net Sales Value |  |  |  |  |  | 0
Large Plates Quantity Sold |  |  | 4182642 | 1936603 | 2312128 | 3690476 | 750009 | 12871858
Large Plates Net Sales Value |  |  | 1068030.23 | 632512.45 | 714446.7000000001 | 1163185.92 | 297850.65 | 3876025.95
Total Quantity Sold |  |  | 10356484 | 5003672 | 6214379 | 9403278 | 1886880 | 32864693
Total Net Sales Value |  |  | 2564396.17 | 1541680.33 | 1829562.67 | 2858566.57 | 775442.5499999998 | 9569648.29