title: Select from dropdown item and return multiple attributes
body: <p>I'm trying to make a food trace ability list and I am trying to help speed up the process of completing it.</p>
  
  <p>I have put all my seed stock into a table under an excel tab called stock.</p>
  
  <p>Stock Table
  <a href="https://i.stack.imgur.com/15car.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/15car.png" alt="enter image description here"></a></p>
  
  <p>I've then made a list from that table.</p>
  
  <p>I've then applied data validation list to <code>column C</code></p>
  
  <p>Food traceability page
  <a href="https://i.stack.imgur.com/3sRxE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3sRxE.png" alt="enter image description here"></a></p>
  
  <p>I'm basically trying to make it so when I select a seed from the drop down it autocomplete the batch to save me filling it in.</p>
  
  <p>I've tried using the following formula and it is returning "Seed Batch"  (Table Column Name)</p>
  
  <p>Anyone able to help?</p>