title: Excel - Formula to find first value meeting criteria in a specified range
body: <p>I have a unique date/time value in one worksheet (we will call it WS1).</p>
  
  <h2>   Date &amp; Time</h2>
  
  <p>01/01/2016 12:00:00</p>
  
  <p>In another worksheet, I have two columns set up - we will call it WS2.</p>
  
  <h2>   Date &amp; Time</h2>
  
  <p>01/01/2016 11:00:00</p>
  
  <p>01/01/2016 11:30:00</p>
  
  <p>01/01/2016 12:00:00</p>
  
  <p>01/01/2016 12:30:00</p>
  
  <p>.....</p>
  
  <h2>Decimal Value</h2>
  
  <p>63.8</p>
  
  <p>62.3</p>
  
  <p>61.9</p>
  
  <p>60.1</p>
  
  <p>....</p>
  
  <p>My goal is to use the value in WS1 to find the matching reference cell in WS2's date &amp; time column. The referenced cell is then offset by 1 column to enter the decimal value column.</p>
  
  <p>We now have the address to the corresponding value cell to the date &amp; time in WS1. I now wish to specified range from this value cell to the bottom of the list of cells.</p>
  
  <p>Once the range is specified, I wish to find the address of the first cell that matches a particular criteria in the range. For the purpose of this requirement, I will specify the logical evaluation to be Value &lt; 60.5 .
  Once the first cell matching this criteria has its address identified, I wish to offset this address and find the corresponding date &amp; time.</p>
  
  <p>Steps summary:</p>
  
  <ol>
  <li>Find address of matching date &amp; time value from WS1 in WS2</li>
  <li>Offset this address by 1 column to obtain the adjacent cell reference</li>
  <li>Specify a range from this "adjacent cell reference" to the end of the values column</li>
  <li>Find address of first value in values column that meets logic requirement</li>
  <li>Offset this address by -1 to move back to date &amp; time column</li>
  <li>Obtain value from the address in step 5</li>
  </ol>
  
  <p>Thanks for any help.
  I am trying to use INDIRECT, INDEX, MATCH, ADDRESS and OFFSET functions but I may have to just do it in VBA.</p>