Only way is to have a big nested IF condition on the calculated field. IF(field row = 1,IF(column=1,1,IF(column=2,2,IF(column=3,3,0))), IF(field row = 2,IF(column=1,4,IF(column=2,5,IF(column=3,6,0))) IF(field row = 3,IF(column=1,7,IF(column=2,8,IF(column=3,9,0))) IF(field row = 4,IF(column=1,10,IF(c...