Search for specific list of words in a column and return specified values in another column

[samst]

Hi There I've been searching through the forum (please feel free to point me to the right post if I missed it) and couldn't find what I was looking for so I was wondering if someone might be able to help.

Trying to identify a macro that will search a column of cells for certain words and if it finds one of those words it will return a specific value in another column. For example:

Column A
Twister
Rainstorm
Thunderstorm
Clear day

If the macro finds the word "Thunderstorm" I would like it to return the word "Cloudy" in column B but if it finds the word "Twister" it should return the word "Tornado" etc..

Basically I want to be able to add to the list of words to search for and specify what value it should return.

ANY help would be greatly appreciated.

 

[Aladin Akyurek]

Try something like:

F2, copied down:

=LOOKUP(9.99999999999999E+307,SEARCH(" "&WordList&" "," "&E2&" "),WordList)

where E2 houses a target string.