Retrieve data from Column A based on condition from Column B

I have a set of data in a column. Say like below:

Col A Sets
Apple 1
Apple 1
Apple 1
Orange 2
Orange 2
Orange 2
Pear 3
Pear 3
Pear 3
Mango 4
Mango 4


I want to retrieve the value from col A based on unique values in column (Sets). For an example for sets =1 retrieve Apple. For sets =2 retrieve orange. For sets =3 retrieve pear. How do I do this using macro? Please help. Very much appreciated.

Thanks!