Help with OFFSET function

**diegobraido** · 10-05-2018, 04:12 PM

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
So 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
Thank you very much for your help

**protonLeah** · 10-05-2018, 04:45 PM

=INDEX(Sheet2!$D$18:$J$18,2*ROW(A1)-1)

**diegobraido** · 10-05-2018, 06:29 PM

It works, thank you very much

Help with OFFSET function

LinkBack

Thread Tools

Rate This Thread

Display

Help with OFFSET function

Re: Help with OFFSET function

Re: Help with OFFSET function

Thread Information

Users Browsing this Thread

Similar Threads

Using MATCH function as a reference point for finding a range using the OFFSET function

Trouble identifying nth instances using match/index function with offset function

Using OFFSET function to return the value from another cell with row and column offset

[SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result

match function inside offset function to autofill a formula to start at end of prev series

function similar to offset to offset the offset

[SOLVED] Offset function with nested match function not finding host ss.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions