title: A3 = B3, next day I will need the formula to change to A3 = B4, help please
body: <p>I need some big help on this.</p>
  
  <p>I need to increment my cell references in a formula everytime some condition is used.</p>
  
  <p>Let's say i take my data to be displayed in A3 from B3, my formula will be A3 = B3 in simple terms, but the next day I will need A3 to take data from B4 instead as B3 will be my past data already, how will I increment the formula to change to A3 = B4? Forgive me on my ignorance.</p>