I have two pages that I am referencing between. On the first page I have a list that constantly changes. I have one cell that will have a number between 1 and 140, say cell V9. And 18 other cells ,E28:e36, that will have varying numbers related to the first cell. On the second page I am trying to reference the first page to collect the entered numbers. It has a row for each number 1-140 and the other 18 cells on the same row. I can use an If then, with a circular reference, that way when V9 changes it will not update the other 18 cells after that, but there has to be a better way. I know there is not an if then stop function, but is there a way to stop once the if then statement is true, and once it changes to keep the true number? Any help would be appreciated.
