Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Searching for a range of values within a range of values

Avatar of cyber-33
cyber-33Flag for United States of America asked on
Microsoft Excel
5 Comments1 Solution115 ViewsLast Modified:
I have an excel sheet Sheet1 with a set of text data values (20-50 words) in column A.
An excel sheet Sheet2 stores a set of keywords in Col. A.

I need a macro that loops through each value in Sheet1/Col.1, and searches for each values listed in Sheet2/Col.A. If it finds one or more values, the one or more values should be written in Sheet1/Col.B, If the macro does not find any values, the corresponding Cell. in Sheet1/Col. B should display not found.

Example:

INPUT:

ColA/Sheet 1
A1 = "This is a test string"
A2 = "this is another value"

ColA/Sheet2
test
string
macro

OUTPUT:
ColA/Sheet 1
A1 = "This is a test string", B1 = "test, string"
A2 = "this is another value", B2 = "NOT FOUND"

THANK YOU, EXPERTS!
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn RayFlag of United States of America imageUS Data Team Lead
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers