title: Excel - How to lookup multiple values in comma separated range
body: <p>I have this comma separated values in column A in and corresponding values in column B.</p>
  <p>I want to lookup values of column E and return the values in column F where duplicate values return the next corresponding value of the same match.</p>
  <p><a href="https://i.stack.imgur.com/ZkK64.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZkK64.jpg" alt="excel lookup" /></a></p>
  <p>I have tried this formulae but did not get the desired results</p>
  <pre><code>    =INDEX($B$2:$B$13, SMALL(IF(&quot;*&quot;&amp;E2&amp;&quot;*&quot;=$A$2:$A$13, 
  ROW($A$2:$A$16116)-MIN(ROW($A$2:$A$13))+1, 0), 
  COUNTIF(E2:$E$2, E2)))
  </code></pre>
  <p>Please anyone here to help me?</p>