In the example below, if row 9 has a series of numbers outputted starting at J10 onward and Row 10 if I want to refer to cell I9 once a trigger even occurs, then have all subsequent cells after a trigger event, be J9, K9, L9, how would I do this? F16 in this example is set at 1. The other cells / numbers are as shown. I need output from cell J9 to appear in K10, and K9 to appear in L10, etc,The first part of the formula (=IF) determines in which cell the output from I9 first appears in Row 10, but from that moment on, I need the rest of the outputs that follow to be from J9, K9, L9 ETC. in each cell from that point onward to the right. In the formula if I refer to $I$9, OR I9 or $I9 or I$9, I get the wrong outputs in subsequent cells of Row 10 as I drag the formula to the right. Any help would be appreaciated. t A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data. Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. How about this fomula in I10: and drag it tot the right. 7 additional answers Anonymous 2023-02-27T19:31:25+00:00 Beautiful! Bingo. Thank you so much Jan, it works perfectly. 0 comments No comments Beautiful! Bingo. Thank you so much Jan, it works perfectly. Anonymous 2023-02-27T16:58:05+00:00 The following formula is recommended: (in I10) =IF(($I$4+$F$16)<=I4,H9,"0") Copy the format in I10 to all subsequent cells. F16 always ensures that the first cell will show 0. The formula only needs to consider the display from the second cell onwards. If you have any questions, please feel free to reply. Thank you for the reply. That still does not solve the issue, and it is hard to explain and hard to understand. I have the field F16 set up so I can enter any number. I4 = 1 (as in Month 1) J4=2 (as in Month 2) K4=3 (as in Month 3) etc In most cases I will want to view the projections where F16 is set from 0 to 5. If I enter 0 IN F16, there is an output in cell I10 because =IF(($I$4+$F$16)<=I4 triggers this F16=0 & I4=1, so 0+1=1 which is less than or equal to I4 (Month 1 or 1). If I enter 1 IN F16, there is an output starting in cell J10. If I enter 2 IN F16, there is an output in cell K10. If I enter 3 IN F16, there is an output in cell L10. If I enter 4 IN F16, there is an output in cell M10. ETC. The problem is, I always need the first cell where an output appears to come from “I9”. Then, every cell to the right of that must be pulling from the next cell one by one. If I enter 0 IN F16, there is an output in cell I10 and it needs to pull from “I9”. But J10 needs to pull from J9. And K10 needs to pull from K9. If I enter 1 IN F16, there is an output starting in cell J10 (and it needs to pull from “I9”.) But then in K10 I need data from J9, and in L10 I need data from K9 etc. If I enter 2 IN F16, there is an output in cell K10 (and it needs to pull from “I9”.), BUT then I need data in L10 to come from J9, and data in M10 to come from K9 etc. If I enter 3 IN F16, there is an output in cell L10 (and it needs to pull from “I9”.). BUT then I need data in M10 to come from J9, and data in N10 to come from K9 etc. If I enter 4 IN F16, there is an output in cell M10 (and it needs to pull from “I9”.). ETC. BUT then I need data in N10 to come from J9, and data in O10 to come from K9 data in P10 to come from L9 ETC. So, wherever the data first shows up (cell I10, J10, K10, L10, M10, N10… the output always has to come from I9, then the next cell to the right must come from J9, then K9 etc. I use I4 as the first month a sale is made, but the revenue may show up in the same month or 1 month later, or 2 months or 3 months later etc, and I use F16 to change when the revenue start to show in one of the cells of row 10 (based on the delay I select in F16. So in this case the suggestion does not work, but I think I had not fully explained the issue I am having. I hope the above helps. The issue is that until I enter a number in F16, I do not know which cell in row 10 will have the first output but whenever that is (based on the number entered in F16, it needs to start with output from I9, then the next cell over to the right J9, etc 0 comments No comments The following formula is recommended: (in I10) =IF(($I$4+$F$16)<=I4,H9,"0") Copy the format in I10 to all subsequent cells. F16 always ensures that the first cell will show 0. The formula only needs to consider the display from the second cell onwards. If you have any questions, please feel free to reply. Thank you for the reply. That still does not solve the issue, and it is hard to explain and hard to understand. I have the field F16 set up so I can enter any number. I4 = 1 (as in Month 1) J4=2 (as in Month 2) K4=3 (as in Month 3) etc In most cases I will want to view the projections where F16 is set from 0 to 5. If I enter 0 IN F16, there is an output in cell I10 because =IF(($I$4+$F$16)<=I4 triggers this F16=0 & I4=1, so 0+1=1 which is less than or equal to I4 (Month 1 or 1). If I enter 1 IN F16, there is an output starting in cell J10. If I enter 2 IN F16, there is an output in cell K10. If I enter 3 IN F16, there is an output in cell L10.

If I enter 4 IN F16, there is an output in cell M10. ETC. The problem is, I always need the first cell where an output appears to come from “I9”. Then, every cell to the right of that must be pulling from the next cell one by one. If I enter 0 IN F16, there is an output in cell I10 and it needs to pull from “I9”. But J10 needs to pull from J9. And K10 needs to pull from K9. If I enter 1 IN F16, there is an output starting in cell J10 (and it needs to pull from “I9”.) But then in K10 I need data from J9, and in L10 I need data from K9 etc. If I enter 2 IN F16, there is an output in cell K10 (and it needs to pull from “I9”.), BUT then I need data in L10 to come from J9, and data in M10 to come from K9 etc. If I enter 3 IN F16, there is an output in cell L10 (and it needs to pull from “I9”.). BUT then I need data in M10 to come from J9, and data in N10 to come from K9 etc. If I enter 4 IN F16, there is an output in cell M10 (and it needs to pull from “I9”.). ETC. BUT then I need data in N10 to come from J9, and data in O10 to come from K9 data in P10 to come from L9 ETC. So, wherever the data first shows up (cell I10, J10, K10, L10, M10, N10… the output always has to come from I9, then the next cell to the right must come from J9, then K9 etc. I use I4 as the first month a sale is made, but the revenue may show up in the same month or 1 month later, or 2 months or 3 months later etc, and I use F16 to change when the revenue start to show in one of the cells of row 10 (based on the delay I select in F16. So in this case the suggestion does not work, but I think I had not fully explained the issue I am having. I hope the above helps. The issue is that until I enter a number in F16, I do not know which cell in row 10 will have the first output but whenever that is (based on the number entered in F16, it needs to start with output from I9, then the next cell over to the right J9, etc Anonymous 2023-02-27T04:09:02+00:00 Hi Helprequested123, Welcome to the Microsoft Community. I may not have a perfect answer right away. The following formula is recommended: (in I10) =IF(($I$4+$F$16)<=I4,H9,"0") Copy the format in I10 to all subsequent cells. F16 always ensures that the first cell will show 0. The formula only needs to consider the display from the second cell onwards. If you have any questions, please feel free to reply. Best regards Pondsi 0 comments No comments Hi Helprequested123, Welcome to the Microsoft Community. I may not have a perfect answer right away. The following formula is recommended: (in I10) =IF(($I$4+$F$16)<=I4,H9,"0") Copy the format in I10 to all subsequent cells. F16 always ensures that the first cell will show 0. The formula only needs to consider the display from the second cell onwards. If you have any questions, please feel free to reply. Best regards Pondsi Anonymous 2023-02-27T03:03:17+00:00 <br> --- <br> --- In the above question where =IF(($I$4+$F$16)<=I4,$I$9,"0") is the formula that gets inserted into cell I10, F16 is a fixed number that can be changed and this causes the first instance of a number greater than to appear once F16 is added to the number in cells I4 and onward to the right. The problem is that once the first number appears in row 10 that is greater than zero, it is supposed to be pulled from I9... then the next number in the cell to the right should be pulled from J9, then K9, then L9 and so on. But I cannot figure out how to refer to I4 at the time the first number greater than zero appears. 0 comments No comments The problem is that once the first number appears in row 10 that is greater than zero, it is supposed to be pulled from I9... then the next number in the cell to the right should be pulled from J9, then K9, then L9 and so on. But I cannot figure out how to refer to I4 at the time the first number greater than zero appears.