Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I need to make 1 column in excel equal to another but I have 2 issues: - columns are in different sheets - values in the first columns are placed in direct successive rows, but values in the other are placed in cells incremented by 4 rows each time

means if columns are in A & B, we should have A1=B2, A2=B6, A3=B10, ...

Thank u in advance

share|improve this question

2 Answers

up vote 2 down vote accepted

In A1:

=INDEX(Sheet2!B:B,(ROW(A1)*4-2)
share|improve this answer
Hi - I tried your answer on new excel sheet , it worked - but I tried it to match a columns starting B8, B9, B10,... in sheet "Crank D" to a column B4, B8, B12, ... in sheet "Bar B", I didn't succeed. Kindly which formula syntax to use – user193407 Jan 28 at 14:40
In B8, put INDEX('Crank D'!$B:$B,(ROW(B8)-8)*4+8) – Peter Albert Jan 28 at 14:54
I switched "Crank D" with "Bar B" It worked but it started giving me the sequence from B8 in sheet "Bar B". what to change so it starts giving me the sequence from B4 in sheet " Bar B " – user193407 Jan 28 at 15:03
Look, you also have to make some effort here! Try to understand how the formula works - then adjusting it to your needs is really easy! :-) – Peter Albert Jan 28 at 15:08
:D ok just give me this answer. n I promise I will make the effort for the rest – user193407 Jan 28 at 15:13
show 1 more comment
up vote 0 down vote

If you use OFFSET then the rules might be easier to follow, e.g.

=OFFSET('Crank D'!B$4,(ROWS(B$8:B8)-1)*4,0)

The bold parts are those that are variable....

'Crank D'!B$4 is the first value you want

B8 is the first cell in which you enter the formula

4 is the number of rows between each entry you want

Change those 3 as required

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.