From: nandu1256 on
I have a table for marks of students. I have their ranking in the last col.
In the next sheet I have another table in which I want the names of the first
three to come. Is there any method?
From: Jacob Skaria on
Hi Nandu

Assuming you have names in ColA and ranks in ColE try the below formula in
Sheet2 and copy down to three cells.

=INDEX(Sheet1!A:A,MATCH(ROW(A1),Sheet1!E:E,0))

--
Jacob


"nandu1256" wrote:

> I have a table for marks of students. I have their ranking in the last col.
> In the next sheet I have another table in which I want the names of the first
> three to come. Is there any method?