title: What is an equivalent for INDEX in ARRAYFORMULA?
body: <p>I have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values based on row and column indices.</p>
  
  <p>How can I do that in an ARRAYFORMULA like this?:</p>
  
  <pre><code>=ARRAYFORMULA(INDEX(x!C2:C, F1:F))
  </code></pre>
  
  <p><code>x</code> is the sheet holding the values, I am interested in column C, row index being held in my column F. Single value lookup like <em>INDEX(x!C2:C, F7)</em> is working as expected.</p>
  
  <p>But the ARRAYFORMULA sadly it's not working since INDEX is not supported in ARRAYFORMULA I guess.</p>