Retrieve data from Column A based on condition from Column B

Closed
ashjey29
Posts
3
Registration date
Monday November 23, 2015
Status
Member
Last seen
January 22, 2016
- Nov 24, 2015 at 01:41 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Dec 1, 2015 at 12:25 PM
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!

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Nov 24, 2015 at 09:12 PM
if you flip the columns then you can use vlookup, else you have to use combination of indirect, address, and match
0
How do i do it using combination of indirect, address and match? i have huge amount of data to do this operation. Thanks.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769 > ashjey29
Dec 1, 2015 at 12:25 PM
Then it would be expensive in term of performance. One alternate way would be to use a user defined formula or still most easy route would be to have column A, appear after the "Set" column
0