Excel 2007 : Search for multiple keywords in a text cell; then look at another if not found

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.

Originally Posted by NBVC

You do realise the the 0 returned from Vlookup means that a match is found in the Toggles sheet, just that there is nothing in column D?

If so, then try:

Please Login or Register  to view this content.

This worked great! Thanks so much.
I hadn't considered why the zero was there.
Cheers!