Multiple values, show second or third

Hi there,

I've got a list with some double values in column A. Column B and C contain additional information regarding the value in column A. Now i want to show the values of B and C on another sheet of the second entry of a particular value from column A. Idem for the third entry. How can i solve this?

For example: you used a Refer-a-friend form, where you also have to include your own e-mailadres. You did this three times, so your mailadress is three times on the list. Now i want to find the name of the friend you entered the second time.

Thanks in advance!