=IF(SUMPRODUCT(--ISNUMBER(SEARCH("*"&Keywords!$A$1:$A$12&"*",'main column'!O2)))>0,'main column'!Q2," ")

However, I have another list, in Keywords2!$A$1:$A$12, and I would like the formula to only return the adjacent cell (main column'!Q2) if 'main column'!O2 contains a word from 'Keywords $A$1:$A$12' AND Keywords2!$A$1:$A$12

Thank you.