Hi,
I am trying to find multiple keywords of text within a sentence contained in a range of cells.
For example, in column F I have a series of job titles. In columns J and K I have 'Industry' and 'Focus'. I want to have excel search column F for keywords like "Highway", "Planning", or "Operations" and report in the Industry and Focus columns (i.e. if F2 contains the text Highway then Industry= Urban Roads; if F2 is equal to Planning then Industry is equal to Active Transport).
I have been using the 'search' function with an IF logicial statement, but my fxn would become quite long once I enter all the different keyword possibilities.
Thanks for your help.
Nick