Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 204
- Office Version
- 365
- Platform
- Windows
Hello,
Any help is greatly appreciated ....
Data - I have an excel in which Column A has a specific term
Colum B has different wesbites
Colum C - Result
Requisite
Is there a way to go to each website in colum B and search for the corresponding key term found in Column A
Example
A1
Mark
B1
http://www.phys.psu.edu/people/
C1 (If the key term is found then Give C1 as Found
If not found then give as Manual
---------------
Next row
A2 John
B2 Different URl
C2 -
---------
Then go to the next row A2 B2 and C2
Likewise search through the entire list
------------------------------------
Any help is greatly appreciated ....
Data - I have an excel in which Column A has a specific term
Colum B has different wesbites
Colum C - Result
Requisite
Is there a way to go to each website in colum B and search for the corresponding key term found in Column A
Example
A1
Mark
B1
http://www.phys.psu.edu/people/
C1 (If the key term is found then Give C1 as Found
If not found then give as Manual
---------------
Next row
A2 John
B2 Different URl
C2 -
---------
Then go to the next row A2 B2 and C2
Likewise search through the entire list
------------------------------------