E F H K A B C D 1 Date Old Bay Black Truffle Sea Salt and Caramel 2 2019-08-01 239 83 209 3 2019-08-02 225 185 77 4 2019-08-03 45 165 5 2019-08-04 240 93 177 6 2019-08-05 195 215 110 Daily Total (# sold) Daily Total ($) Sales Goal Met? 531 $3,186 yes 487 $2,922 yes 366 $2,196 yes 510 $3,060 yes 520 $3,120 yes $6 $1,500 $2,762 $720 $4,248 156 $ $ $ 3,000.00 $7 25 126 263 26 251 196 37 204 29 98 273 $ 8/19/2019 $ $ 29 210 269 150 224 55 70 221 240 $ 7 2019-08-06 8 2019-08-07 9 2019-08-08 10 2019-08-09 11 2019-08-10 12 2019-08-11 13 2019-08-12 14 2019-08-13 25 2019-08-14 26 2019-08-15 27 2019-08-16 18 2019-08-17 19 2019-08-18 20 2019-08-19 21 2019-08-20 22 2019-08-21 23 2019-08-22 24 2019-08-23 25 2019-08-24 26 2019-08-25 27 2019-08-26 28 2019-08-27 29 2019-08-28 30 2019-08-29 31 2019-08-30 32 2019-08-31 206 J with Price Increase Current price per box: $ 3,460 Daily sales goal: $ 3,174 Average daily sales: $ 2,385 Lowest daily sales: $ 3,324 Highest daily sales: 3,389 Average sales with 2,665 price increase $ 2,444 New price per box: $ 2,874 2,633 Lookup date: 782 Sales goal met? 3.558 $ 3,988 $ 2,998 $ 2,046 4,190 $ 1,818 $ 2,965 $ 3,063 $ 2,528 $ 2,255 $ 2,776 3,128 $ 4,614 $ 3,526 $ 4,418 $ 3.741 2,861 2,392 $ 2,835 $ 3,161 $ 3,011 133 53 141 174 62 238 70 86 189 182 43 143 169 121 66 240 132 241 233 237 265 85 38 222 30 53 274 166 409 375 441 404 120 546 612 460 314 643 279 455 470 388 346 426 480 708 541 678 574 439 367 435 485 462 259 27 101 $2,454 yes $2,250 yes $2,646 yes $2,424 yes $720 no $3,276 yes 53,672 yes $2,760 yes $1,884 yes $3,858 yes $1,674 yes $2,730 yes $2,820 yes $2,328 yes $2,076 yes $2,556 yes $2,880 yes $4,248 yes $3,246 yes $4,068 yes $3,444 yes $2,634 yes $2,202 yes $2,610 yes $2,910 yes $2,772 yes 211 69 114 81 72 267 194 $ 42 273 255 273 266 168 54 165 274 25 121 114 $ 189 55 188 $ 119 91 245 257 n. In cell K11, enter a formula using VLOOKUP to display whether or not the sales goal was met for the date listed in cell K10. Use the named range Sales Data for the Table_array argument. The formula should return the value in the Sales Goal Met? column (column 7 in the data array) only when there is an exact match