Transaction | Product ID | Unit Sales Amount |
1 | dcq | $ 1,704 |
2 | gft | $ 4,458 |
3 | csz | $ 4,835 |
4 | wcd | $ 1,605 |
5 | qmg | $ 1,079 |
6 | hgy | $ 3,945 |
7 | ggr | $ 2,444 |
8 | hvf | $ 872 |
9 | vaj | $ 1,545 |
10 | acj | $ 2,635 |
11 | ilw | $ 2,377 |
12 | sna | $ 3,626 |
13 | dov | $ 1,029 |
14 | ppa | $ 3,511 |
15 | gwy | $ 4,803 |
16 | tcb | $ 2,583 |
17 | mey | $ 3,045 |
18 | bfg | $ 2,624 |
19 | exr | $ 3,826 |
20 | joy | $ 3,377 |
21 | dao | $ 4,885 |
22 | cvc | $ 2,370 |
23 | mxd | $ 3,441 |
24 | sgf | $ 2,011 |
Trying to use Vlookup formula and match function that will show the product ID code of the product with the largest unit sales.