autofill according to cell index

H

honour

for example I fill B1 cell with D3.And I want to fill the other B
cells(B2,B3...) with the D(3+n) .The n is a constant.For example n=2. That is
why B2=D5 or B3=D7.How can I do that??Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help calculating probabilities 7
conditional format/compare 7
autofill according to cell index. 1
If Condition 0
Filtering data 2
IF/AND/OR Statements 0
series of formulas to get to one formula 0
trouble with (complicated) vlookup searching another workbook 2

Top