Data to another sheet

N

nandu1256

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?
 
J

Jacob Skaria

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))
 
Top