So I think I generally understand how the "*" wildcard with vlookup works, but I need an "inverse" wildcard.
Below is an example of my challenges:
I have a list of Responses (column B) (over 2000 responses) that vary significantly but I need to recode it based on the "sample table" For example, any time a person mentions "college" it is coded as "School - College/University/Vocational;" anytime a person mentions "Work" or "Internship" in their response, it is coded as "Through Work"
In a vlookup, my lookup_value is A2 ("technical college") and my table array is E1:F8, my col index is 2.
Any suggestions to get the those responses with the word "college" any where in the response to be coded as "School - College/University/Vocation?"
Thank you!
Below is an example of my challenges:
I have a list of Responses (column B) (over 2000 responses) that vary significantly but I need to recode it based on the "sample table" For example, any time a person mentions "college" it is coded as "School - College/University/Vocational;" anytime a person mentions "Work" or "Internship" in their response, it is coded as "Through Work"
In a vlookup, my lookup_value is A2 ("technical college") and my table array is E1:F8, my col index is 2.
Any suggestions to get the those responses with the word "college" any where in the response to be coded as "School - College/University/Vocation?"
Thank you!