jlindner wrote:
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

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.