Hi @Melissa ,
Using the mcode I would like to return the category from “refence” table instead of using if statement.
At the moment I used the below code:
if Text.Contains([Desc], “bank fee”) then “Finance” else if Text.Contains([Desc], “fire call”) then “Fire” else if Text.Contains([Desc], “deposit”) then “Finance” else 0)
I would like to replace the above with Text.Contains using other table “Refence”
If we would look for an exact match we could use the below:
Could you please advise?
Please find the attached excel files.
Thank you Matty