See this screencap:

http://img513.imageshack.us/img513/7177/file1lw1.jpg

The formula used is an array formula. Array formulas need to be entered
using the key combination of CTRL,SHIFT,ENTER (not just ENTER).

--
Biff
Microsoft Excel MVP


"Xcel" <Xcel @discussions.microsoft.com wrote in message
...
i picked top10 values with the help of the large formula from an array of
values, on that i wrote match function, with the help of the match
function
values i wrote index for getting respective name for the value.its working
propely when the values are not repeated if any value repeated large
working
properly but match was giving the first match value only,for that i need
individual match values. pls anyone help me.
1 san
10 raj
9 cami
12 jhon

Regards,
Santhosh.