skaisdead22
New Member
- Joined
- Dec 17, 2020
- Messages
- 15
- Office Version
- 2013
- Platform
- Windows
Hello,
Lets say I have 2 columns (A and B) containing different strings in either column.
I have a certain value (ex. "apple") that I would like to search these two columns for. The specific cells may contain additional data (ex. A1 = "apple, banana, berry). Depending on which column my value (apple) is found in, I would like the macro to return a value (ex. "fruit") if it located in column A and return (ex. "vegetable) if it is found in column B.
I would like results ("fruit" or "vegetable") to go into a new column (C) next to the 2 columns that were just searched.
Happy to provide any additional context as needed.
I appreciate all the skills and support of this community!
Thanks,
Skaisdead22
Lets say I have 2 columns (A and B) containing different strings in either column.
I have a certain value (ex. "apple") that I would like to search these two columns for. The specific cells may contain additional data (ex. A1 = "apple, banana, berry). Depending on which column my value (apple) is found in, I would like the macro to return a value (ex. "fruit") if it located in column A and return (ex. "vegetable) if it is found in column B.
I would like results ("fruit" or "vegetable") to go into a new column (C) next to the 2 columns that were just searched.
Happy to provide any additional context as needed.
I appreciate all the skills and support of this community!
Thanks,
Skaisdead22