Prev: vlookup 3 sheets
Next: Missing alphanumeric number in the sequence
From: nandu1256 on 7 Mar 2010 23:11
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 8 Mar 2010 00:02
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?
 | 
Pages: 1
Prev: vlookup 3 sheets
Next: Missing alphanumeric number in the sequence