I have a list of trigger words in column B and the list needs to be compared to the Comments column (column B). The only formula I am able to create gives me results of True, False or Yes, No. I am needing the formula to return the trigger word in column B. Help would be most appreciated. Thank you very much.
Column A / Column B / Column C
Comments / TriggerWords
Foreclosure is not an option / debt
My APR is too high / 60+
Please forgive my debt / 90+
My bills are late / accelerate
Foreclosure is not an option / annual percentage rate
My APR is too high/ annual percentage yield
Please forgive my debt / APR
My bills are late / APY
Foreclosure is not an option / bonus
My APR is too high / Foreclosure
Please forgive my debt / cancel
My bills are late / charge off
Foreclosure is not an option / collection
Bookmarks