Question: Each month the following table needs to be updated with sales information using the vlookup function.

Please u
"December_Data" to complete this report for December. After this is done . . . also, there is some concern of possible fraud
any duplicate monthly sales numbers in the report below. Answer the question below in green.
Based on the Conditional Formatting results: What Prod

Product_ID
Product Categorys Product Names January February March
27075 Wind 18' Propeller $ 91,030 $ 77,426 $ 85,773
60587 Wind 24' Propeller $ 96,639 $ 12,180 $ 10,323
91400 Wind 28' Propeller $ 41,397 $ 61,792 $ 40,622
41574 Wind Biway Directional Gauge $ 89,043 $ 93,528 $ 89,222
90417 Wind Capacitor $ 98,885 $ 27,189 $ 43,371
59503 Hydro Cavitation diffuser $ 15,390 $ 96,276 $ 66,733
88658 Hydro Cavitation diffuser limiter $ 89,113 $ 60,666 $ 80,487
57228 Hydro Cavitation diffuser pro $ 26,653 $ 97,248 $ 58,789
82784 Solar Cell Casing $ 72,265 $ 12,262 $ 17,919
74772 Hydro Control Gate $ 91,983 $ 17,232 $ 10,115
86545 Hydro Control Gate 24" $ 68,354 $ 15,163 $ 80,113
42663 Hydro Control Gate lever $ 73,728 $ 77,764 $ 57,223
98597 Hydro Curtailment gauge $ 37,245 $ 51,522 $ 82,472
44307 Hydro Curtailment gauge 10d $ 23,094 $ 75,262 $ 81,085
59691 Hydro Curtailment gauge axillary $ 78,167 $ 33,301 $ 29,253
64651 Wind Directional Gauge $ 40,593 $ 23,174 $ 58,028
26293 Hydrogen Electrochemical converter $ 72,887 $ 96,893 $ 23,439
56121 Hydrogen Electrochemical processer inverter $ 43,944 $ 73,438 $ 72,293
95276 Hydrogen Electro-signal processer $ 73,212 $ 32,658 $ 36,940
50137 Hydrogen Entropy Gauge $ 12,805 $ 24,637 $ 45,313
58675 Hydrogen Entropy Gauge limited $ 80,075 $ 56,826 $ 79,587
98888 Hydrogen Entropy Gauge spacer $ 46,133 $ 36,755 $ 23,719
21963 Wind Flux Capacitor $ 50,156 $ 15,796 $ 74,384
63661 Hydro Frequency converter $ 60,557 $ 72,987 $ 24,085
90528 Hydro Frequency converter buckler $ 64,268 $ 52,344 $ 35,479
24168 Hydro Frequency converter max $ 15,525 $ 45,190 $ 56,780
47831 Hydrogen Fuel Cell Casing $ 56,098 $ 95,979 $ 28,936
14212 Solar Gold Cell Casing $ 36,652 $ 21,637 $ 29,704
44393 Hydrogen Gold Fuel Cell Casing $ 82,917 $ 51,816 $ 89,468
54388 Wind Gold turbine casing $ 20,171 $ 62,540 $ 38,463
91438 Solar Heat Transfer $ 38,392 $ 13,025 $ 96,053
40362 Solar Heat Transfer Box $ 77,011 $ 92,132 $ 18,275
95327 Solar Heat Transfer Coil $ 67,243 $ 99,425 $ 67,176
25458 Wind Inward Directional Gauge $ 81,564 $ 91,482 $ 97,156
67622 Solar Platinum Cell Casing $ 45,188 $ 88,235 $ 26,164
97526 Hydrogen Platinum Fuel Cell Casing $ 74,753 $ 98,209 $ 82,843
12174 Wind Platinum turbine casing $ 28,643 $ 97,159 $ 15,342
85178 Solar Solar Power Converter $ 49,694 $ 50,583 $ 94,923
40549 Solar Solar Power Converter max $ 97,533 $ 97,322 $ 90,601
85065 Solar Solar Power Converter stabilizer $ 30,065 $ 97,864 $ 97,416
35817 Wind Tunnel Capacitor $ 65,103 $ 35,792 $ 98,622
24790 Wind turbine casing $ 43,062 $ 96,901 $ 20,203
23337 Wind Wind Power Converter $ 60,214 $ 42,961 $ 62,763
81554 Wind Wind Power Converter box $ 52,950 $ 16,485 $ 31,265
20700 Wind Wind Power Converter stabilizer $ 75,157 $ 11,767 $ 24,809
$ 2,635,551 $ 2,600,823 $ 2,473,729
ookup function. Please use the vlookup function and the
concern of possible fraud. Use Conditional Formatting to identify

atting results: What Product Category should we look into for possible fraud? The Control Gate and Cviatation catego

Product Sales by Month for 2023

April May June July August September October
$ 52,698 $ 45,374 $ 86,788 $ 66,340 $ 47,115 $ 27,427 $ 67,269
$ 10,119 $ 86,601 $ 70,446 $ 26,192 $ 63,812 $ 63,232 $ 26,469
$ 90,287 $ 20,812 $ 55,841 $ 93,894 $ 66,809 $ 33,850 $ 18,460
$ 20,031 $ 26,825 $ 60,241 $ 45,610 $ 20,538 $ 34,506 $ 97,856
$ 83,738 $ 48,897 $ 28,091 $ 47,450 $ 46,830 $ 91,671 $ 83,701
$ 53,283 $ 42,726 $ 63,107 $ 63,251 $ 41,266 $ 70,401 $ 55,230
$ 32,575 $ 79,182 $ 26,625 $ 77,631 $ 51,052 $ 38,552 $ 76,740
$ 37,628 $ 29,035 $ 72,609 $ 56,618 $ 50,280 $ 54,847 $ 17,795
$ 51,839 $ 94,985 $ 56,602 $ 36,523 $ 48,085 $ 65,228 $ 16,315
$ 11,830 $ 93,405 $ 43,345 $ 43,090 $ 85,879 $ 57,448 $ 75,564
$ 87,176 $ 91,398 $ 71,016 $ 70,926 $ 59,656 $ 51,347 $ 15,162
$ 75,469 $ 68,459 $ 91,398 $ 82,318 $ 48,535 $ 93,973 $ 81,469
$ 15,062 $ 97,846 $ 32,589 $ 62,246 $ 31,531 $ 43,303 $ 61,928
$ 79,242 $ 88,140 $ 81,384 $ 67,344 $ 78,412 $ 33,741 $ 47,359
$ 76,042 $ 31,313 $ 80,169 $ 33,675 $ 12,256 $ 74,434 $ 32,270
$ 32,752 $ 33,906 $ 49,476 $ 81,350 $ 75,594 $ 63,129 $ 60,450
$ 20,484 $ 84,479 $ 72,036 $ 96,321 $ 19,318 $ 83,041 $ 54,729
$ 30,001 $ 34,570 $ 10,746 $ 73,205 $ 59,956 $ 28,395 $ 17,258
$ 65,130 $ 24,799 $ 84,785 $ 18,967 $ 84,828 $ 49,905 $ 43,502
$ 74,557 $ 31,986 $ 19,413 $ 31,780 $ 46,948 $ 78,987 $ 10,171
$ 54,642 $ 23,099 $ 62,280 $ 74,841 $ 99,304 $ 14,551 $ 99,814
$ 41,828 $ 69,286 $ 32,400 $ 76,055 $ 10,870 $ 30,762 $ 28,783
$ 19,525 $ 45,871 $ 17,765 $ 83,146 $ 82,976 $ 77,800 $ 87,395
$ 16,739 $ 11,346 $ 71,092 $ 82,778 $ 27,242 $ 50,459 $ 41,398
$ 16,734 $ 13,234 $ 43,992 $ 57,456 $ 15,777 $ 82,991 $ 42,160
$ 76,611 $ 39,167 $ 84,842 $ 79,253 $ 38,453 $ 63,980 $ 57,438
$ 70,146 $ 53,470 $ 79,771 $ 36,620 $ 21,282 $ 60,370 $ 35,460
$ 89,456 $ 90,343 $ 82,829 $ 95,945 $ 97,806 $ 31,546 $ 73,632
$ 11,788 $ 27,392 $ 46,782 $ 53,038 $ 76,547 $ 91,851 $ 22,638
$ 42,759 $ 56,753 $ 53,012 $ 17,985 $ 92,310 $ 53,323 $ 48,092
$ 45,749 $ 69,839 $ 81,643 $ 16,325 $ 27,473 $ 20,076 $ 59,597
$ 11,688 $ 58,379 $ 30,110 $ 88,507 $ 51,259 $ 91,796 $ 12,842
$ 65,895 $ 72,157 $ 30,208 $ 41,946 $ 96,752 $ 94,369 $ 99,454
$ 98,879 $ 17,083 $ 81,797 $ 75,741 $ 64,498 $ 88,363 $ 59,389
$ 96,243 $ 11,174 $ 38,299 $ 32,509 $ 88,268 $ 94,723 $ 53,444
$ 22,322 $ 70,371 $ 72,449 $ 97,334 $ 49,041 $ 40,479 $ 37,175
$ 61,963 $ 93,943 $ 86,689 $ 57,544 $ 27,544 $ 97,004 $ 83,138
$ 74,965 $ 44,421 $ 53,422 $ 72,944 $ 48,733 $ 35,752 $ 32,503
$ 36,385 $ 82,673 $ 91,958 $ 65,460 $ 38,429 $ 66,076 $ 21,553
$ 65,803 $ 46,303 $ 84,525 $ 71,556 $ 39,350 $ 52,632 $ 72,267
$ 19,465 $ 11,472 $ 80,039 $ 50,811 $ 69,538 $ 79,602 $ 23,447
$ 25,770 $ 86,480 $ 19,346 $ 61,342 $ 42,424 $ 18,225 $ 15,216
$ 98,917 $ 53,727 $ 94,052 $ 43,536 $ 59,609 $ 42,346 $ 74,098
$ 82,826 $ 31,467 $ 79,386 $ 53,114 $ 83,100 $ 55,546 $ 24,305
$ 97,369 $ 43,220 $ 20,132 $ 95,767 $ 16,351 $ 59,198 $ 92,270
$ 2,344,410 $ 2,377,408 $ 2,675,527 $ 2,756,284 $ 2,403,636 $ 2,631,237 $ 2,257,205
e Control Gate and Cviatation categories

November December Total

$ 66,604 $ 46,608 $ 760,452
$ 86,818 $ 53,303 $ 606,134
$ 67,172 $ 83,389 $ 674,325
$ 48,117 $ 52,348 $ 677,865
$ 17,948 $ 77,196 $ 694,967
$ 77,294 $ 50,378 $ 695,335
$ 94,905 $ 11,638 $ 719,166
$ 75,613 $ 91,398 $ 668,513
$ 49,615 $ 40,214 $ 561,852
$ 54,871 $ 67,229 $ 651,991
$ 44,793 $ 36,379 $ 691,483
$ 74,112 $ 98,876 $ 923,324
$ 54,547 $ 76,962 $ 647,253
$ 65,142 $ 89,599 $ 809,804
$ 16,771 $ 39,362 $ 537,013
$ 64,451 $ 12,593 $ 595,496
$ 13,174 $ 29,749 $ 666,550
$ 44,336 $ 28,320 $ 516,462
$ 60,379 $ 52,729 $ 627,834
$ 80,543 $ 95,453 $ 552,593
$ 96,977 $ 96,548 $ 838,544
$ 12,246 $ 58,350 $ 467,187
$ 65,845 $ 85,901 $ 706,560
$ 91,281 $ 44,169 $ 594,133
$ 88,828 $ 74,147 $ 587,410
$ 44,122 $ 16,196 $ 617,557
$ 68,175 $ 96,277 $ 702,584
$ 69,501 $ 81,220 $ 800,271
$ 56,722 $ 79,232 $ 690,191
$ 46,824 $ 55,890 $ 588,122
$ 60,755 $ 47,829 $ 576,756
$ 56,216 $ 34,100 $ 622,315
$ 47,947 $ 17,623 $ 800,195
$ 62,797 $ 63,447 $ 882,196
$ 44,020 $ 79,671 $ 697,938
$ 36,182 $ 81,211 $ 762,369
$ 19,193 $ 56,609 $ 724,771
$ 78,937 $ 34,393 $ 671,270
$ 73,653 $ 58,953 $ 820,596
$ 39,592 $ 75,516 $ 772,889
$ 32,827 $ 34,873 $ 601,591
$ 61,695 $ 45,834 $ 536,498
$ 94,777 $ 16,295 $ 743,295
$ 82,121 $ 50,553 $ 643,118
$ 51,224 $ 42,741 $ 630,005
$ 2,639,662 $ 2,561,301 $ 30,356,773
Question: Each month the following table needs to be updated with sales information using the xlookup function. Please u
"December_Data" to complete this report for December. After this is done . . . use conditional formatting to highlight all sa

Product_ID
Product Categorys Product Names January February March
27075 Wind 18' Propeller $ 91,030 $ 77,426 $ 85,773
60587 Wind 24' Propeller $ 96,639 $ 12,180 $ 10,323
91400 Wind 28' Propeller $ 41,397 $ 61,792 $ 40,622
41574 Wind Biway Directional Gauge $ 89,043 $ 93,528 $ 89,222
90417 Wind Capacitor $ 98,885 $ 27,189 $ 43,371
59503 Hydro Cavitation diffuser $ 15,390 $ 96,276 $ 66,733
88658 Hydro Cavitation diffuser limiter $ 89,113 $ 60,666 $ 80,487
57228 Hydro Cavitation diffuser pro $ 26,653 $ 97,248 $ 58,789
82784 Solar Cell Casing $ 72,265 $ 12,262 $ 17,919
74772 Hydro Control Gate $ 91,983 $ 17,232 $ 10,115
86545 Hydro Control Gate 24" $ 68,354 $ 15,163 $ 80,113
42663 Hydro Control Gate lever $ 73,728 $ 77,764 $ 57,223
98597 Hydro Curtailment gauge $ 37,245 $ 51,522 $ 82,472
44307 Hydro Curtailment gauge 10d $ 23,094 $ 75,262 $ 81,085
59691 Hydro Curtailment gauge axillary $ 78,167 $ 33,301 $ 29,253
64651 Wind Directional Gauge $ 40,593 $ 23,174 $ 58,028
26293 Hydrogen Electrochemical converter $ 72,887 $ 96,893 $ 23,439
56121 Hydrogen Electrochemical processer inverter $ 43,944 $ 73,438 $ 72,293
95276 Hydrogen Electro-signal processer $ 73,212 $ 32,658 $ 36,940
50137 Hydrogen Entropy Gauge $ 12,805 $ 24,637 $ 45,313
58675 Hydrogen Entropy Gauge limited $ 80,075 $ 56,826 $ 79,587
98888 Hydrogen Entropy Gauge spacer $ 46,133 $ 36,755 $ 23,719
21963 Wind Flux Capacitor $ 50,156 $ 15,796 $ 74,384
63661 Hydro Frequency converter $ 60,557 $ 72,987 $ 24,085
90528 Hydro Frequency converter buckler $ 64,268 $ 52,344 $ 35,479
24168 Hydro Frequency converter max $ 15,525 $ 45,190 $ 56,780
47831 Hydrogen Fuel Cell Casing $ 56,098 $ 95,979 $ 28,936
14212 Solar Gold Cell Casing $ 36,652 $ 21,637 $ 29,704
44393 Hydrogen Gold Fuel Cell Casing $ 82,917 $ 51,816 $ 89,468
54388 Wind Gold turbine casing $ 20,171 $ 62,540 $ 38,463
91438 Solar Heat Transfer $ 38,392 $ 13,025 $ 96,053
40362 Solar Heat Transfer Box $ 77,011 $ 92,132 $ 18,275
95327 Solar Heat Transfer Coil $ 67,243 $ 99,425 $ 67,176
25458 Wind Inward Directional Gauge $ 81,564 $ 91,482 $ 97,156
67622 Solar Platinum Cell Casing $ 45,188 $ 88,235 $ 26,164
97526 Hydrogen Platinum Fuel Cell Casing $ 74,753 $ 98,209 $ 82,843
12174 Wind Platinum turbine casing $ 28,643 $ 97,159 $ 15,342
85178 Solar Solar Power Converter $ 49,694 $ 50,583 $ 94,923
40549 Solar Solar Power Converter max $ 97,533 $ 97,322 $ 90,601
85065 Solar Solar Power Converter stabilizer $ 30,065 $ 97,864 $ 97,416
35817 Wind Tunnel Capacitor $ 65,103 $ 35,792 $ 98,622
24790 Wind turbine casing $ 43,062 $ 96,901 $ 20,203
23337 Wind Wind Power Converter $ 60,214 $ 42,961 $ 62,763
81554 Wind Wind Power Converter box $ 52,950 $ 16,485 $ 31,265
20700 Wind Wind Power Converter stabilizer $ 75,157 $ 11,767 $ 24,809
$ 2,635,551 $ 2,600,823 $ 2,473,729
ookup function. Please use the xlookup function and the
matting to highlight all sales amounts that are above $90,000.

Product Sales by Month for 2023

April May June July August September October
$ 52,698 $ 45,374 $ 86,788 $ 66,340 $ 47,115 $ 27,427 $ 67,269
$ 10,119 $ 86,601 $ 70,446 $ 26,192 $ 63,812 $ 63,232 $ 26,469
$ 90,287 $ 20,812 $ 55,841 $ 93,894 $ 66,809 $ 33,850 $ 18,460
$ 20,031 $ 26,825 $ 60,241 $ 45,610 $ 20,538 $ 34,506 $ 97,856
$ 83,738 $ 48,897 $ 28,091 $ 47,450 $ 46,830 $ 91,671 $ 83,701
$ 53,283 $ 42,726 $ 63,107 $ 63,251 $ 41,266 $ 70,401 $ 55,230
$ 32,575 $ 79,182 $ 26,625 $ 77,631 $ 51,052 $ 38,552 $ 76,740
$ 37,628 $ 29,035 $ 72,609 $ 56,618 $ 50,280 $ 54,847 $ 17,795
$ 51,839 $ 94,985 $ 56,602 $ 36,523 $ 48,085 $ 65,228 $ 16,315
$ 11,830 $ 93,405 $ 43,345 $ 43,090 $ 85,879 $ 57,448 $ 75,564
$ 87,176 $ 91,398 $ 71,016 $ 70,926 $ 59,656 $ 51,347 $ 15,162
$ 75,469 $ 68,459 $ 91,398 $ 82,318 $ 48,535 $ 93,973 $ 81,469
$ 15,062 $ 97,846 $ 32,589 $ 62,246 $ 31,531 $ 43,303 $ 61,928
$ 79,242 $ 88,140 $ 81,384 $ 67,344 $ 78,412 $ 33,741 $ 47,359
$ 76,042 $ 31,313 $ 80,169 $ 33,675 $ 12,256 $ 74,434 $ 32,270
$ 32,752 $ 33,906 $ 49,476 $ 81,350 $ 75,594 $ 63,129 $ 60,450
$ 20,484 $ 84,479 $ 72,036 $ 96,321 $ 19,318 $ 83,041 $ 54,729
$ 30,001 $ 34,570 $ 10,746 $ 73,205 $ 59,956 $ 28,395 $ 17,258
$ 65,130 $ 24,799 $ 84,785 $ 18,967 $ 84,828 $ 49,905 $ 43,502
$ 74,557 $ 31,986 $ 19,413 $ 31,780 $ 46,948 $ 78,987 $ 10,171
$ 54,642 $ 23,099 $ 62,280 $ 74,841 $ 99,304 $ 14,551 $ 99,814
$ 41,828 $ 69,286 $ 32,400 $ 76,055 $ 10,870 $ 30,762 $ 28,783
$ 19,525 $ 45,871 $ 17,765 $ 83,146 $ 82,976 $ 77,800 $ 87,395
$ 16,739 $ 11,346 $ 71,092 $ 82,778 $ 27,242 $ 50,459 $ 41,398
$ 16,734 $ 13,234 $ 43,992 $ 57,456 $ 15,777 $ 82,991 $ 42,160
$ 76,611 $ 39,167 $ 84,842 $ 79,253 $ 38,453 $ 63,980 $ 57,438
$ 70,146 $ 53,470 $ 79,771 $ 36,620 $ 21,282 $ 60,370 $ 35,460
$ 89,456 $ 90,343 $ 82,829 $ 95,945 $ 97,806 $ 31,546 $ 73,632
$ 11,788 $ 27,392 $ 46,782 $ 53,038 $ 76,547 $ 91,851 $ 22,638
$ 42,759 $ 56,753 $ 53,012 $ 17,985 $ 92,310 $ 53,323 $ 48,092
$ 45,749 $ 69,839 $ 81,643 $ 16,325 $ 27,473 $ 20,076 $ 59,597
$ 11,688 $ 58,379 $ 30,110 $ 88,507 $ 51,259 $ 91,796 $ 12,842
$ 65,895 $ 72,157 $ 30,208 $ 41,946 $ 96,752 $ 94,369 $ 99,454
$ 98,879 $ 17,083 $ 81,797 $ 75,741 $ 64,498 $ 88,363 $ 59,389
$ 96,243 $ 11,174 $ 38,299 $ 32,509 $ 88,268 $ 94,723 $ 53,444
$ 22,322 $ 70,371 $ 72,449 $ 97,334 $ 49,041 $ 40,479 $ 37,175
$ 61,963 $ 93,943 $ 86,689 $ 57,544 $ 27,544 $ 97,004 $ 83,138
$ 74,965 $ 44,421 $ 53,422 $ 72,944 $ 48,733 $ 35,752 $ 32,503
$ 36,385 $ 82,673 $ 91,958 $ 65,460 $ 38,429 $ 66,076 $ 21,553
$ 65,803 $ 46,303 $ 84,525 $ 71,556 $ 39,350 $ 52,632 $ 72,267
$ 19,465 $ 11,472 $ 80,039 $ 50,811 $ 69,538 $ 79,602 $ 23,447
$ 25,770 $ 86,480 $ 19,346 $ 61,342 $ 42,424 $ 18,225 $ 15,216
$ 98,917 $ 53,727 $ 94,052 $ 43,536 $ 59,609 $ 42,346 $ 74,098
$ 82,826 $ 31,467 $ 79,386 $ 53,114 $ 83,100 $ 55,546 $ 24,305
$ 97,369 $ 43,220 $ 20,132 $ 95,767 $ 16,351 $ 59,198 $ 92,270
$ 2,344,410 $ 2,377,408 $ 2,675,527 $ 2,756,284 $ 2,403,636 $ 2,631,237 $ 2,257,205
 November December Total
$ 66,604 $ 46,608 $ 760,452
$ 86,818 $ 53,303 $ 606,134
$ 67,172 $ 83,389 $ 674,325
$ 48,117 $ 52,348 $ 677,865
$ 17,948 $ 77,196 $ 694,967
$ 77,294 $ 50,378 $ 695,335
$ 94,905 $ 11,638 $ 719,166
$ 75,613 $ 91,398 $ 668,513
$ 49,615 $ 40,214 $ 561,852
$ 54,871 $ 67,229 $ 651,991
$ 44,793 $ 36,379 $ 691,483
$ 74,112 $ 98,876 $ 923,324
$ 54,547 $ 76,962 $ 647,253
$ 65,142 $ 89,599 $ 809,804
$ 16,771 $ 39,362 $ 537,013
$ 64,451 $ 12,593 $ 595,496
$ 13,174 $ 29,749 $ 666,550
$ 44,336 $ 28,320 $ 516,462
$ 60,379 $ 52,729 $ 627,834
$ 80,543 $ 95,453 $ 552,593
$ 96,977 $ 96,548 $ 838,544
$ 12,246 $ 58,350 $ 467,187
$ 65,845 $ 85,901 $ 706,560
$ 91,281 $ 44,169 $ 594,133
$ 88,828 $ 74,147 $ 587,410
$ 44,122 $ 16,196 $ 617,557
$ 68,175 $ 96,277 $ 702,584
$ 69,501 $ 81,220 $ 800,271
$ 56,722 $ 79,232 $ 690,191
$ 46,824 $ 55,890 $ 588,122
$ 60,755 $ 47,829 $ 576,756
$ 56,216 $ 34,100 $ 622,315
$ 47,947 $ 17,623 $ 800,195
$ 62,797 $ 63,447 $ 882,196
$ 44,020 $ 79,671 $ 697,938
$ 36,182 $ 81,211 $ 762,369
$ 19,193 $ 56,609 $ 724,771
$ 78,937 $ 34,393 $ 671,270
$ 73,653 $ 58,953 $ 820,596
$ 39,592 $ 75,516 $ 772,889
$ 32,827 $ 34,873 $ 601,591
$ 61,695 $ 45,834 $ 536,498
$ 94,777 $ 16,295 $ 743,295
$ 82,121 $ 50,553 $ 643,118
$ 51,224 $ 42,741 $ 630,005
$ 2,639,662 $ 2,561,301 $ 30,356,773
Data used for 1_Vlookup question to complete monthly sales report.

2023
Product_ID Product_Category Product_Name December_Sales
24168 Hydro Frequency converter max $ 46,608
42663 Hydro Control Gate lever $ 53,303
44307 Hydro Curtailment gauge 10d $ 83,389
57228 Hydro Cavitation diffuser pro $ 52,348
59503 Hydro Cavitation diffuser $ 77,196
59691 Hydro Curtailment gauge axillary $ 50,378
63661 Hydro Frequency converter $ 11,638
74772 Hydro Control Gate $ 91,398
86545 Hydro Control Gate 24" $ 40,214
88658 Hydro Cavitation diffuser limiter $ 67,229
90528 Hydro Frequency converter buckler $ 36,379
98597 Hydro Curtailment gauge $ 98,876
26293 Hydrogen Electrochemical converter $ 76,962
44393 Hydrogen Gold Fuel Cell Casing $ 89,599
47831 Hydrogen Fuel Cell Casing $ 39,362
50137 Hydrogen Entropy Gauge $ 12,593
56121 Hydrogen Electrochemical processer inverter $ 29,749
58675 Hydrogen Entropy Gauge limited $ 28,320
95276 Hydrogen Electro-signal processer $ 52,729
97526 Hydrogen Platinum Fuel Cell Casing $ 95,453
98888 Hydrogen Entropy Gauge spacer $ 96,548
14212 Solar Gold Cell Casing $ 58,350
40362 Solar Heat Transfer Box $ 85,901
40549 Solar Solar Power Converter max $ 44,169
67622 Solar Platinum Cell Casing $ 74,147
82784 Solar Cell Casing $ 16,196
85065 Solar Solar Power Converter stabilizer $ 96,277
85178 Solar Solar Power Converter $ 81,220
91438 Solar Heat Transfer $ 79,232
95327 Solar Heat Transfer Coil $ 55,890
12174 Wind Platinum turbine casing $ 47,829
20700 Wind Wind Power Converter stabilizer $ 34,100
21963 Wind Flux Capacitor $ 17,623
23337 Wind Wind Power Converter $ 63,447
24790 Wind turbine casing $ 79,671
25458 Wind Inward Directional Gauge $ 81,211
27075 Wind 18' Propeller $ 56,609
35817 Wind Tunnel Capacitor $ 34,393
41574 Wind Biway Directional Gauge $ 58,953
54388 Wind Gold turbine casing $ 75,516
60587 Wind 24' Propeller $ 34,873
64651 Wind Directional Gauge $ 45,834
81554 Wind Wind Power Converter box $ 16,295
90417 Wind Capacitor $ 50,553
91400 Wind 28' Propeller $ 42,741
Question: Use the sumif formula to provide a Sales total by Category when that category is selected from a drop down men
in cell B6. Create the menu list under "Category list" and state each of the four categories.

Total Sales 2023

by Category Category List
Select Category
Sales by Category
ected from a drop down menu
Question: Using the index and match formulas make it so that when a different month is selected in cell F6 that the report
updates with sales figures for the month. Put a dropdown list in cell F6 for each possible month listed on the 1_vlookup wor
Answer the following questions by selecting the appropriate Month.

1. What was total Hydro sales for the month of September?

2. What was total Solar sales for the month of March?
3. What was total Wind Sales for the month of May?

2023 Sales
Month

24168 Hydro Frequency converter max

42663 Hydro Control Gate lever
44307 Hydro Curtailment gauge 10d
57228 Hydro Cavitation diffuser pro
59503 Hydro Cavitation diffuser
59691 Hydro Curtailment gauge axillary
63661 Hydro Frequency converter
74772 Hydro Control Gate
86545 Hydro Control Gate 24"
88658 Hydro Cavitation diffuser limiter
90528 Hydro Frequency converter buckler
98597 Hydro Curtailment gauge
Hydro Total $ -
26293 Hydrogen Electrochemical converter
44393 Hydrogen Gold Fuel Cell Casing
47831 Hydrogen Fuel Cell Casing
50137 Hydrogen Entropy Gauge
56121 Hydrogen Electrochemical processer inverter
58675 Hydrogen Entropy Gauge limited
95276 Hydrogen Electro-signal processer
97526 Hydrogen Platinum Fuel Cell Casing
98888 Hydrogen Entropy Gauge spacer
Hydrogen Total $ -
14212 Solar Gold Cell Casing
40362 Solar Heat Transfer Box
40549 Solar Solar Power Converter max
67622 Solar Platinum Cell Casing
82784 Solar Cell Casing
85065 Solar Solar Power Converter stabilizer
85178 Solar Solar Power Converter
91438 Solar Heat Transfer
95327 Solar Heat Transfer Coil
Solar Total $ -
12174 Wind Platinum turbine casing
20700 Wind Wind Power Converter stabilizer
21963 Wind Flux Capacitor
23337 Wind Wind Power Converter
24790 Wind turbine casing
25458 Wind Inward Directional Gauge
27075 Wind 18' Propeller
35817 Wind Tunnel Capacitor
41574 Wind Biway Directional Gauge
54388 Wind Gold turbine casing
60587 Wind 24' Propeller
64651 Wind Directional Gauge
81554 Wind Wind Power Converter box
90417 Wind Capacitor
91400 Wind 28' Propeller
Wind Total $ -
Total Monthly Sales $ -
ed in cell F6 that the report automatically
isted on the 1_vlookup worksheet.
Question: Using the data at B5:P50 on 1_Vlookup create a pivot stacked area graph below. Move the columns in the pivot
create two slicers. One slicer should be for Product Categorys. The other Slicer should be for Product Names. Use the grap
1. Which product category did you put on the top of the chart that has the smallest December sales?
2. Based on the stacked area chart which Month appears to have had the highest amount of total sales?
3. Using the slicers which of the propeller Product Names (Wind category) has the Lowest March sales?
4. Using the slicers what appears to be lowest month of the year for total propeller (18', 24' & 28') related sales?
 w. Move the columns in the pivot tab so that the graph is arranged from biggest on the bottom to smallest at the top based on Decemb
e for Product Names. Use the graph and the slicers to answer the following four questions.
mber sales?
of total sales?
March sales?
4' & 28') related sales?
allest at the top based on December sales. Then