hi guys
im looking to return an answer in cell c28
in b28 it will say "best goalkeeper"
in c28 i need a formula to look in range d2:d6 then return the highest answer and correspond that to whats in b2: b6
so we could say
(b2)shilton(d2) 33
(b3)corrigan (d3) 55
(b4)parkes (d4) 66
(b5)schmeichel (d5) 100
(b6)cudicini (d6) 14
in c28 it will return the answer schmeichel because he is the highest
and in d28 it would return the points he has
thanks in advance
Bookmarks