Incrementing Cell Reference Within INDIRECT function

[IronDogg]

How do I increment the cell reference to the following row within the INDIRECT function?
i.e I want to "fill down" this formula in column F, picking up all the adjacent values in column G. All cells are currency.

Please Login or Register  to view this content.

End objective for using INDIRECT() is that I want to be able to insert new columns between F & G and always have F referencing G as the previous values in column G shift rightwards.

Thanks in advance for any advice.

[daddylonglegs]

Do you need the IF? if G7 is truly blank then it will be interpreted as zero anyway, try this version to fill down

=INDIRECT("G"&ROW())

or use OFFSET

=OFFSET(F7,0,1)

[IronDogg]

Awesome! Thanks for the quick response!

The IF was the start of a further formula which has now evolved to the following based on the data that is in the currency column G (I put an aesthetic spacer column in there):

Please Login or Register  to view this content.

Then in a separate sheet, a column will reference column E above, and if it is zero, it will IF an error "Call for current price" or something else...

Can I ask what is the difference in the OFFSET and INDIRECT functions and what is an example of when it is best to use whichever option instead of the other?

Thanks again!

[Cadtiger]

Similar request- I want to copy values in column A1:A500 into Column B, but row location of column b data would increment by 3. e.g A1 copies to B1, then A2 copies to B4, A3 to B7....

[arlu1201]

Cadtiger,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.