Thank for the replies,

dredwolf, the formula you suggested causes a #VALUE! error. I think there might be a circular reference issue.

AlKey, your method also has potential. It returns values higher than what they should be though right now. Can you explain what the bolded part does "C"&ROW(4:4)*4-12 as well as why you chose to use ROW($A2) instead of another indirect string?