Trying to use Vlookup and Match

yessir

Board Regular
Joined
Jun 7, 2019
Messages
81
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.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,662
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
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:

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,308
Office Version
  1. 365
  2. 2010
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,813
Messages
5,574,483
Members
412,596
Latest member
nickthebizz
Top