#### Frank Bacchus

##### Member

This may be a simple answer:

I have an excel sheet with a key and a number. The only thing is the key repeats and the number may be different. I would like to do a vlookup and get (as a result) the highest number for that key. For example:

key - number

1 - 4

1 - 5

1 - 7 My vlookup result should be 7

2 - 10 My vlookup result should be 10

3 - 2 My vlookup result should be 2

4 - 6

4 - 7

4 - 9

4 - 11 My vlookup result should be 11

Simple - what is the vlookup formula?

thanks

frank