Automatically enter numbers depending on the cell previous

[masterpinuk]

Hi all thanks for reading this first of all! I need some help with something I thought was relatively simple but clearly not. What I need the spreadsheet to do is:
if a cell in column c is a 1 then I need the cell next to it in column d be 67. If it's 2 then 69 so on and so forth up to 30. Is there an easy way to do this. Just to make get hints a little complicated I need it to happen for column e and f but different numbers and g and h with different numbers as well. Thanks again

 

[FormR]

Hi, welcome to the forum!

if a cell in column c is a 1 then I need the cell next to it in column d be 67. If it's 2 then 69 so on and so forth up to 30.

Is there a logical progression, i.e. does it start at 67 and increase by 2 every time the number in column C increases by 1?