title: how to evalute the value in excel, need help in formula
body: <p>I need to populate the value in Column D.
  I'm not getting the result using the formula. In the second row, instead of Arun I am getting kumar.</p>
  
  <p>the formula i am using is <code>=IFERROR(INDEX($A$2:$A$10000,MATCH(B2,$C$2:$C$10000,0)),A2)</code></p>
  
  <p><a href="https://i.stack.imgur.com/j74aW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/j74aW.png" alt="New Updated excel"></a></p>