pick Match Formula Simplify

[anwarbham]

Hi 

Im trying to group a set of accounts and with the resulting group assign a new account number.

im using pick match it seem to do the job, but . for every Match i have to add the same new account number 

is there anyway of just setting the new account number once instead of repeating the new account number 20 times 

example is the formula below. if  teh accounts are found in [pnl_code] then assign it  9030000000 

thanks

pick(Match([pnl_code],

 '3010111100',

 '3010111200',

 '3010112100',

 '3010112300',

 '3010113100',

 '3010113200',

 '3010210000',

 '3010220000',

 '3010620000',

 '3010621000',

 '3010631001',

 '3010631002',

 '3010632001',

 '3010641000',

 '3010642000',

 '3010800000',

 '3010910000',

 '3010930000',

 '3010943000',

 '3010944000',

 '3010945000',

 '3012000000',

 '3010115001',

 '3010115002')

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

 ,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000'

,'9030000000')

[DavidM · Accepted solution]

you can simplify it with:

if(match(your list), '9030000000',original value)

However how about making a table (either xls or inline) and the using applymap?

[anwarbham]

i was thinking about using applymap might give it a try