Hi Mike,

I think your best bet is to handle this with a formula. It certainly
looks like it lends itself to a formula solution. If I understand your
layout correctly, you should be able to drop the following formula into
cell G6, and drag copies through your monthly salary range -

=IF($B6$C6,0,IF(G$3$B6,INDEX($D6:$F6,1,G$2)/12,0))

Because the formula uses the index function, you should round your
UseSalary cells to be integers. So, if the formula in the Month1 cell
is -

=OtherSheet3!D12

you should change it to -

=ROUND(OtherSheet3!D12,0)

I hope this helps,

Gary