Table.ReplaceValue help

[Tmk123]

Hello,

I am looking over a personal budget.  I want to update the column Category to "Alcohol" based on a keyword in the description column (case insensitive).  So...if the description contains "wine" or "liquor" change the category to "Alcohol"

I know creating a conditional column is an option but wanted to practice M-queries in power query. 

Amount	Transaction Date	Description	Category	Category (#Update)
$20.00	01/01/2023	Total Wine and More	Merchandise	Alcohol
$10.00	02/01/2023	TOTAL WINE AND MORE	Merchandise	Alcohol
$35.00	03/01/2023	HOMESENSE #02567	Merchandise	Merchandise
$15.00	05/01/2023	ABC Liquor Store	Merchandise	Alcohol

Both columns are Text columns, if important.

The following is not working as intended.  It appears what I wrote below requires the description to be an exact match for the entire cell.  I want it to search each record in the category column for a single word, regardless of the case.

= Table.ReplaceValue(
#"Replaced Value1",
each [Category],
each if
Text.Contains([Description], "liquor", Comparer.OrdinalIgnoreCase) and
Text.Contains([Description], "wine", Comparer.OrdinalIgnoreCase)
then "Groceries"
else [Category],
Replacer.ReplaceText,
{"Category"})

Thanks for your help!!!

[Tmk123]

Thanks a lot, ThxAlot .  That worked!

[ThxAlot · Accepted solution]

= Table.ReplaceValue(Source, each [Category], each if List.Contains({"wine","liquor"},[Description],(x,y)=>Text.Contains(y,x,Comparer.OrdinalIgnoreCase)) then "Alcohol" else [Category], Replacer.ReplaceText, {"Category"})