Google Sheets IFS Formula Builder

Column reference (e.g. F2)

Creditor Groups

Each group = one normalised name (e.g. HMRC, BRITISH GAS) and a list of keywords/variants (one per line).

Generated Formula