Power Query return if exact match...similar words like SUM SUMIFS SUMIF SUMPRODUCT

[raffrobb]

How do I extract an exact matching word from a column/string in Power Query (Get & Transform). Column string could be very variable such as IF blah blah, or blah blah SUM blah, or blah SUMPRODUCT...
For example, I want the result to be return SUM if SUM, SUMPRODUCT if SUMPRODUCT, SUMIF if SUMIF, SUMIFS if SUMIFS.

Thanks
Robb

 

[Ken Puls]

Something like this?

Formula for an Add Column -> Custom Column

Text.Contains(Text.Lower([Look In]),Text.Lower(Term))

Replace Term with "SUM" (in quotes), or create a separate query that drills down to the term like the attached.