Search / Vlookup

Hi. Im just new here and not really that good in excel software. Just wanna ask if is it possible to combine SEARCH function and VLOOKUP function. Because i wanted to search for a particular name: example

in column A

excel programming
how to use excel
basic excel guides
basic codes for ..........
codes for ..........
programming codes........

in column B

here i will make a querry for column B from column A where i will search for a string like "EXCEL" w/c will return a value like "HI!" and if im looking for a word "CODES" it will return "HELLO"...

in short i have a lot of criteria to be searched and that i will use SEARCH function (because it is not case sensitive unlike VLOOKUP that has limited function)..

Hoping for you great help.
thanks