How do you use VLOOKUP to rank each product according the table on the right of the screen shot based off of the yearly sales? The table is named Rank.

Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF E sro e02_grader_hw_B-Trendz Adam Ronaldo Home Insert Draw Page Layout Formulas Data >> >> Tell me Share o Comments fx | Logical AutoSum Recently Used v Insert Function Financial A Text v Date & Time v Defined Names Formula Auditing Calculation Options to J3 1 x fx D E F H I J K L M N 1 B-Trendz, Inc. 2018 Quarterly Sales 2 Product Line Online Ranking Product A YES NO Broduct Line Rank 0 E 500,000 D 1,000,000 1,250,000 B 1,500,000 A YES A B YES B YES D NO 3 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance 4 4 5 65 745,777 732,937 740,375 2,953,854 6 98 256,789 255,936 251,529 1,000,452 7 00 478,123 477,229 472,721 1,885,073 8 89 311,987 312,892 315,837 1,253,505 9 65 413,726 414,756 419,202 1,671,149 10 46 201,725 200,273 194,768 779,512 11 76 291,234 293,745 297,312 1,175,767 12 82 197,315 198,295 193,800 782,192 13 27 281,334 280,687 285,111 1,131,059 14 87 125,079 126,213 121,510 497,389 15 47 242,703 245,666 247,897 976,113 16 87 310,719 306,827 245,321 1,097,854 17 69 3,856,511 3,845,456 3,785,383 15,212,919 18 Women's Clothing Sales NO D 3,000,000 E NO NO NO NO NO 2,500,000 D 2,000,000 1,500,000 1,000,000 lililili 500,000 1 2 3 4 5 6 7 8 Men's Clothing Sales Product Line Online 19 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Product 20 21 21 446,123 449,154 451,876 1,792,474 YES 22 87 325,968 331,825 337,345 1,320,125 B YES 23 10 269,432 272,045 274,123 1,082,810 NO 24 76 394,836 395,185 395,987 1,578,884 A YES 25 46 284,998 293,199 300,154 1,162,097 NO 26 49 184,316 186,978 185,285 739,228 D NO 27 17 301,512 310,936 312,123 1,219,088 NO 28 36 226,897 229,465 232,000 910,398 D NO 29 54 97,312 98,251 97,945 392,762 E NO 30 75 122,978 126,253 127,423 499,129 E NO 31 45 94,968 90,156 98,127 384,596 E NO 32 78 79,196 83,926 76,293 315,393 E NO 33 94 2,828,536 2,867,373 2,888,681 11,396,984 Retail Sales Comparison Predictions Online 1,800,000 1,600,000 1,400,000 1,200,000 1,000,000 800,000 600,000 400.000 W + Enter + 100% LIC Ps Pr Ai w P