C

#### ChuckUK

On sheet alpha I have a simple three column table;

A B C

1 Peter 5 6

2 David 12 9

3 Mike 7 2

4 Fred 2 7

5 Peter 9 1

On sheet bravo, i want to enter a formula that looks at sheet alpha

then looks for Mike and then tells me the number next to that person.

have found a way to do this using the lookup function like this;

=LOOKUP("Mike",alpha!a1:a5,alpha!b1:b5)

=LOOKUP("Mike",alpha!a1:a5,alpha!c1:c5)

Where I am having problems is if the person is named twice, I need th

formula to display the highest number of the two people from the colum

I choose, let's say column B.

So for Peter I would want the number 9 on column b and next to it th

corresponding number from column c, 1.

I don't want to sort any of the data on sheet alpha, so all the wor

needs to be done on sheet bravo