In a word - Messy! To avoid a series of IFs, I would, instead, create a series of boolean modules dimensioned by Code to be mapped and the different rule logic for the different codes/number patterns. Some do not apply, as per your example, Code C, D ,E and F are not applicable for Mapped Codes A-F, so you would set those to TRUE. You will probably need line items for each pattern, but splitting it up this way is the most efficient, but you will need to update the formulas/add more Can you post some example data to help understand the formats of Code A - Code F patterns? It's always easier to work with data than the theory David David
... View more