Hi,
I am attempting to assign industry and focus specializations to individuals based upon keywords found in their job title.
I have a column of keywords with corresponding values where the search begins, but I want excel to use information contained on another worksheet if it is unable to match a keyword to a word in the job title.
Example (see attached workbook):
Would like to search column D for keywords like "Highway" or "Planning" or "Operations" and have column E andF automatically update with corresponding industry and focus information. If that information is not available in Column D, I would like to have Excel vlookup using Column C (employer) and find the corresponding information in the lookup array in the worksheet called 'Toggles' in column D (1o Industry).
The function I created seems to work somewhat, but I don't want '0' entries if excel doesn't find the info it is looking for. Rather, I would like it to report 'Not Defined'. Other ways of doing this would also be appreciated.
Thanks.
Bookmarks