title: Return value in Excel when the sum of values in two columns exceed a specified value
body: <p>I have the following data and want to return the value in column A when the sum of a row from B &amp; C exceeds 400 for the first time.</p>
  
  <p>So B7+C7 = 460, so the return value should be A7, whereas B6+C6 was &lt;400.</p>
  
  <p>This is very easy to do if I add a new column and then lookup the value in that column. However my full dataset has 1000 columns and if possible I would like to do this in a single cell above the datasets.</p>
  
  <p><img src="https://i.stack.imgur.com/Qg4ab.png" alt="Sample Data"></p>