Copying a Formula down - increasing letters

[hutchie]

Hi

I have a formula and I want to quickly replicate it.

The formula runs over several cells (left to right):

=IF($G24="Aviation Turbine Fuel",S$24,E150)
=IF($G24="Biofuels",S$27,F150)
=IF($G24="Burning Oil",S$28,G150)

I want to be able to copy the cells and paste them in the row under this however I want to have the $G24 update to $G25 (which it does with a simple copy/paste) but also allow the S$24 to go up to T$24 (or whatever the relevant number is for that formula). Is there a way of doing this?

I have tried pasting in a down one cell and across one cell but unfortunately when updating I need the cells to stay directly underneath each other and doing this means that they end up in a reverse staggered step position.

I fear that this isn't possible - but I live in hope!

I look forward to hearing from you and thanks in advance for any help/advice!

 

[hutchie]

I've solved it - I am an idiot! The reference table including the cells S24/S27/S28 just needed to be transposed - then the references stayed in the same columns but the numbers increased! I think writing it out on here helped!