Previous Topic Next Topic

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 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
ashjey29
Nov 25, 2015 at 10:15 PM
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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > 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

Similar discussions

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses