title: Record values from if Statement to current Cell Excel
body: <p>I have created and excel spreed sheet.
  Its pulls External data from a website into sheet 1.
  On Sheet 2 Is where all my calculations are done.</p>
  
  <p>In Sheet 2..
  <strong>B1</strong> is my Current Value that updates every hour,
  <strong>M1</strong> Is my current Time, 
  <strong>F1</strong> Is my Current Time, 
  <strong>A4:A27</strong> Is my Date Range,
  <strong>B3:Y3</strong> Is my Time Range,
  And I'm using an if statement.<code>=if(AND(F1=A4:A27), (M1=(B3:y3),B1,"")</code>
  If statement works fine. See image Below.
  <a href="https://i.stack.imgur.com/g6b4e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/g6b4e.png" alt="image1"></a>
  You can see on the 20-11-2017 there is a value under the 7 on today date. When the time changes to 8 the 7 value disappears. As see in the second image below. Because of the if statement not being true on the 7 value any longer.
  <a href="https://i.stack.imgur.com/087ZZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/087ZZ.png" alt="image2"></a>
  I'm looking to store the history of the passed values.
  How can i allow the if statement to save the values as a value instead of a reference that keeps changing.</p>