vlookup and max ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get the max # from a worksheet with multiple rows of my key value.

WM-DV028 Windows WDW 25 3/29/2006
WM-DV028 Windows WDW 25 3/30/2006
WM-DV028 Windows WDW 8 3/31/2006
WM-DV028 Windows WDW 3 4/3/2006
WM-DV028 Windows WDW 4 4/4/2006
WM-DV028 Windows WDW 7 4/5/2006
WM-DV028 Windows WDW 24 4/6/2006
WM-DV028 Windows WDW 32 4/7/2006
WM-DV028 Windows WDW 8 4/8/2006

this worksheet has >40 lines this is just a sample.
Is there a way to combine vlookup with max?
 
jlindner said:
I want to get the max # from a worksheet with multiple rows of my key value.

WM-DV028 Windows WDW 25 3/29/2006
WM-DV028 Windows WDW 25 3/30/2006
WM-DV028 Windows WDW 8 3/31/2006
WM-DV028 Windows WDW 3 4/3/2006
WM-DV028 Windows WDW 4 4/4/2006
WM-DV028 Windows WDW 7 4/5/2006
WM-DV028 Windows WDW 24 4/6/2006
WM-DV028 Windows WDW 32 4/7/2006
WM-DV028 Windows WDW 8 4/8/2006

this worksheet has >40 lines this is just a sample.
Is there a way to combine vlookup with max?
Click to expand...

What maximum value are you looking for?
After you get that value, what are you looking to pull from the table?
You need to be more specific.
 
Just hazarding some guesses here ..
(I agree with Mark that you should be more specific)

Assuming the data posted is in cols A to E from row1 down,
where col D is the key col = numbers: 25,25,8,3,4 etc

Put in say, G1:
=INDEX(A:A,MATCH(MAX($D:$D),$D:$D,0))
Copy G1 to K1 to return the source line with the max number in col D
Format K1 as date

Should there be any tied maximum numbers in col D, then only the 1st line
(ie the higher up one) gets returned into G1:K1
 
Back
Top