Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try something like this:
If(Match(Area_Category,'DCB',Money_collection'),
Pick(Match(Area_Category,'DCB',Money_collection'),Replace(Area_Category,'DCB','DEDICATED C'),Replace(Area_Category,'Money_collection','M Col'))
,Area_Category)