title: How do I return the value corresponding to an index selection in an array?
body: <p>I've got form users from different companies making a selection from 1 to 10 and I need to get the corresponding value in an array unique to each user's company.</p>
  <p>Effectively, I think this needs the equivalent of INDEX() in an ARRAYFORMULA(), so I've had a look at the answers to similar questions:</p>
  <blockquote>
  <p><a href="https://stackoverflow.com/questions/16140642/how-to-use-index-inside-arrayformula">How to use INDEX() inside ARRAYFORMULA()?</a></p>
  </blockquote>
  <blockquote>
  <p><a href="https://stackoverflow.com/questions/41527113/what-is-an-equivalent-for-index-in-arrayformula">What is an equivalent for INDEX in ARRAYFORMULA?</a></p>
  </blockquote>
  <p>While these look similar, I can't figure out how to apply the proposed formulas to my challenge - I've tried applying them but get errors I don't understand how to fix.</p>
  <p>I've created a <a href="https://docs.google.com/spreadsheets/d/1PvAVkGmPb3myJUyfB6I5uATPx1u37s8M9s7e_1ApKBs/edit?usp=sharing" rel="nofollow noreferrer">sample spreadsheet</a> to demonstrate the desired results:</p>
  <ul>
  <li>Responses sheet has the form responses</li>
  <li>Reference sheet has the reference values</li>
  <li>Results sheet has the desired result (corresponding value returned based on the index number selected by the user)</li>
  </ul>