title: Random of Table Header Name of another table via INDEX MATCH
body: <p>I have these 2 tables:
  <a href="https://i.stack.imgur.com/4zSOO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4zSOO.png" alt="enter image description here" /></a></p>
  <p>On column B i'm trying to get one of the Header Names of a feature that is not empty on Table B. I want it to be selected <strong>randomly</strong>. The order of the items in Table A can be different than the order of the items in Table B, I'll need some sort of INDEX MATCH here too.</p>
  <p>Excel Version: Office 365</p>
  <p>Attempted Formula: I tried to base my formula on this:</p>
  <pre><code>=INDEX(datarange,RANDBETWEEN(1,COLUMNS(datarange)),1)
  </code></pre>
  <p>but there are more things to consider, like header name if the index match of the same fruit isn't empty, so I know it is more complex.</p>
  <p>Any help will be greatly appreciated.</p>