Auto-Increment Function (Excel)

Question

I have this Formula:

=IF(J3=1,(D3&" "&C3),"")&

I need it to keep auto increment all the way to J70, D70, and C70. 

Is there any way I can do this?

The & is because I need it all to be in one text. Look at my code below for explanation

Right now I have it manually set to =IF(J3=1,(D3&" "&C3),"")&IF(J4=1,(D4&" "&C4),"")&IF(J5=1,(D5&" "&C5),"")... etc

This code gives me. If j3=1 then gives the column d3, and c3.... then adds the text of the next row if its 1.

Answer 1

I am not sure if I understand correctly. Do you mean that you want the data in the previous cell (where the formula is located) concatenated into the value of next returned data? If so, then assume that your first formula is in K3 like the following.

=IF(J3=1,(D3&" "&C3),"")

Then in K4 insert the following formula and copy down.

=K3&" " &IF(J4=1,(D4&" "&C4),"")

Picture of what I am assuming that you want to do.

If above is not what you want then I need more explanation. You might find a picture like the above helpful in providing the explanation. It is created with Snipping Tool. If you have not used Snipping Tool before then find the application and pin it to the Task Bar because that makes it easy to use. I am sure you will be able to follow the prompts to create and save the picture and then on this forum click the Insert Image icon and follow the prompts to upload the picture from the saved location.