title: state and capitals quiz questions how can I map the answers with options
body: <p>I have quiz question like 
  what is the capital of india</p>
  
  <pre><code>a,delhi 
  b,bombay 
  c,chennai 
  d,bengaluru
  </code></pre>
  
  <p>answer in a different column as A 
  I what to put a column which will check the answer a and get the option in the
   result field 
  <img src="https://i.stack.imgur.com/ugPvh.png" alt="enter image description here"></p>
  
  <p><a href="https://i.stack.imgur.com/oYTtF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oYTtF.png" alt="Image of the error I was getting"></a></p>
  
  <p>If I use this function <code>=INDEX(B2:E2,MATCH(F2,$B$1:$E$1,0))</code>  the first and second line is getting answer not sure why the lines like the third are showing NA in result :( @basic
  Hey @basic This is the formula 
  <a href="https://i.stack.imgur.com/sz6Ax.png" rel="nofollow noreferrer">formula I used</a></p>