You can use the LARGE function in combination with Vlookup

A1:A10 are numbers
B1:B10 are names

=VLOOKUP(LARGE(A1:A10,1),A1:B10,2)

Change the 1 to two if you want the second biggest


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Beto" wrote in message ...
Hi, I have a question about this function:

Well it's not exactly that function it's the opposite one (BIG?) I don't
know its name, because in my Excel it's called K.ESIMO.MAYOR.

I have a table with numbers and names and I want the name of the biggest
number, the second biggest, etc... How do I get this through formulas?
numbers may be repeated, but just one would be enough. With
K.ESIMO.MAYOR I can get the biggest number, but now how do I use this in
another formula to get the name? I'm not good with references so can you
help me out?

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.