Trying to use Vlookup and Match

yessir

Board Regular
Joined
Jun 7, 2019
Messages
91
TransactionProduct IDUnit Sales Amount
1dcq$ 1,704
2gft$ 4,458
3csz$ 4,835
4wcd$ 1,605
5qmg$ 1,079
6hgy$ 3,945
7ggr$ 2,444
8hvf$ 872
9vaj$ 1,545
10acj$ 2,635
11ilw$ 2,377
12sna$ 3,626
13dov$ 1,029
14ppa$ 3,511
15gwy$ 4,803
16tcb$ 2,583
17mey$ 3,045
18bfg$ 2,624
19exr$ 3,826
20joy$ 3,377
21dao$ 4,885
22cvc$ 2,370
23mxd$ 3,441
24sgf$ 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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
You don't want to use VLOOKUP as you are looking to the left (please note that your numbers were appearing as text to me and so I had to convert them)...

Book3
ABCDE
1TransactionProduct IDUnit Sales Amount
21dcq$1,704.00dao
32gft$4,458.00
43csz$4,835.00
54wcd$1,605.00
65qmg$1,079.00
76hgy$3,945.00
87ggr$2,444.00
98hvf$872.00
109vaj$1,545.00
1110acj$2,635.00
1211ilw$2,377.00
1312sna$3,626.00
1413dov$1,029.00
1514ppa$3,511.00
1615gwy$4,803.00
1716tcb$2,583.00
1817mey$3,045.00
1918bfg$2,624.00
2019exr$3,826.00
2120joy$3,377.00
2221dao$4,885.00
2322cvc$2,370.00
2423mxd$3,441.00
2524sgf$2,011.00
Sheet1
Cell Formulas
RangeFormula
E2E2=INDEX($B$2:$B$25,MATCH(MAX($C$2:$C$25),$C$2:$C$25,0))
 
Last edited:
Upvote 0
If you indicated in your profile which version you're running, you might be able to use XLOOKUP (only in 365) to look left (and even more features).

Code:
=XLOOKUP(MAX(C2:C25),C2:C25,B2:B25)
 
Upvote 0

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top