FlossieT
New member
- Joined
- Jul 12, 2011
- Messages
- 11
- Reaction score
- 0
- Points
- 0
I'm doing some work on analysing website search terms. I have:
- one worksheet, search_terms, containing all the search terms for a given month
- one worksheet, author_names, containing a list of author names.
I want to add a column to search_terms that sets a flag whenever a name from author_names has been used in search_terms. However, I can only seem to get this working - with vLookup - for an exact match. It's not flagging rows in which, for example, an author name appears along with a subject keyword. So, "Joe Bloggs" returns a 1; "Joe Bloggs cheese" doesn't.
Is there a way to do this, either using vLookup or using something else? I've tried a couple of approaches using wildcards, but I can only seem to get it to work in the other direction (i.e. when the data in search_terms is a subset of the data in author_names).
Many thanks,
Rachael
- one worksheet, search_terms, containing all the search terms for a given month
- one worksheet, author_names, containing a list of author names.
I want to add a column to search_terms that sets a flag whenever a name from author_names has been used in search_terms. However, I can only seem to get this working - with vLookup - for an exact match. It's not flagging rows in which, for example, an author name appears along with a subject keyword. So, "Joe Bloggs" returns a 1; "Joe Bloggs cheese" doesn't.
Is there a way to do this, either using vLookup or using something else? I've tried a couple of approaches using wildcards, but I can only seem to get it to work in the other direction (i.e. when the data in search_terms is a subset of the data in author_names).
Many thanks,
Rachael