We program some of the peoples salaries 50/50 between PQ34 and SQ34 as well as Water and Electricity, that is why I divided by 2. So I need to be able to populate each column (PQ34 & SQ34) with half of their salary if I select "50/50 PQ34-SQ34" in the drop down.

Yes I transposed the numbers so I could use VLookup. Is there an easier way?