Help with OFFSET function

[diegovbs]

Hi guys
I've been struggling with the offset formula and would like to ask for help
I have a serie of values entered on "Sheet 2" that I want to display on a table in "Sheet 1" and I want to be able to apply the formula and use the drag down function
I want to be able to enter a formula in cell A12 in sheet 1 that will copy the value in cell B18 in Sheet 2, then I want to be able to drag down from A12 and copy the value from the cell in every other column in sheet 2 but always in row 18
That way by dragging down from A12: A13 in sheet1 displays value in cell C18 in sheet2; A14 sheet1 displays value in D18 sheet 2 and so on
How can I do that?
Thank you very much for your help

 

[diegovbs]

A small correction
When dragging the formula down from A12 in sheet1:
A13 = D18 from sheet 2
A14 = F18 from sheet 2
A15 = H18 from sheet 2
A16 = J18 from sheet 2
and so on

 

[Eric W]

In A12:

=OFFSET(Sheet2!$B$18,0,(ROWS(A$12:A12)-1)*2)

 

[diegovbs]

Thank you very much, it works

In A12:

=OFFSET(Sheet2!$B$18,0,(ROWS(A$12:A12)-1)*2)

 

[Eric W]

You're welcome.