hi,
Please help on this:
I have list of two columns as shown below:
Rank Names
1 Josh
2 jason
3 darryl
2 mike
4 paul
2 aaron

On a different sheet I want to have a rank input cell, and generate a column
listing all the names corresponding to that rank.
for example
rank 2 (input cell,I enter this value)
output column:
jason
mike
aaron
If I use vlookup function I get the first name in the list (in this case
jason) three times,
how can achieve this?

thanks in advance,