title: Excel formula to fill empty cells in a column with a list from another column/table
body: <p>Looking for an excel formula to auto fill only the empty cells of a column with data form another column/table.</p>
  <p>The ordered list from table1 was created with the formula:
  '=IFERROR(INDEX($A$2:$A$11,SMALL(IF($B$2:$B$11=&quot;yes&quot;,ROW($A$2:$A$11),&quot;&quot;),ROW()-1)-1,1),&quot;&quot;)</p>
  <p>Then I wanted to distribute the list in to the empty cells of a partially filled column in Table2.
  I tried using the formulas:</p>
  <p>=IF(F2&lt;&gt;&quot;&quot;,F2,C2)</p>
  <p>=IF(F2&lt;&gt;&quot;&quot;,F2,ROWS(C$2:C2))</p>
  <p>=IF(J73&lt;&gt;&quot;&quot;,J73,INDEX($C$73:$C$82,AGGREGATE(15,6,ROW($C$73:$C$82)-ROW($C$72)/($C$73:$C$82&lt;&gt;&quot;&quot;),ROWS(C$73:C73))))</p>
  <p>But none of them give me the expected outcome. (see attached image)</p>
  <p>Any suggestions?<br />
  Thank you in advanced.</p>
  <p><a href="https://i.stack.imgur.com/1Af9U.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Af9U.png" alt="enter image description here" /></a></p>