copy contents from one sheet to another if <=

[1cup]

if sheet1 D1 is <= 1-19 then copy contents of D7 Sheet2 to D24 Sheet1. It gets tricky now. I may be overthinking this.... Im curious how you can come up with this solution.

If sheet1 D1 is <= 20-39 then copy contents of D8 Sheet2 to D24 Sheet1. This will go all the way to 1000. The numbers or in increments of 20 as you can see in the spreadsheet.

The point of this is to copy the contents in Column D that coincide with 1-19, 20-39, 40-59... etc.. This will be for future addition to the spreadsheet. THANK YOU!

[Jonmo1]

Try
=INDEX(Sheet2!$D$7:$D$28,CEILING(($D$1+1)/20,1))

Although the book you posted doesn't really jive with your description. D24 on Sheet1 is already populated with a text string.

[1cup]

Yes this works perfectly! Thank you!

[Jonmo1]

You're welcome.