title: Performing Vlookup on duplicate values
body: <p>First of all I know how to perform VLookup for unique values.</p>
  
  <p>Now I have a set of data with me where in the 'Table Array' I have a lot of duplicate values which needs to be associated with a single 'Look UP value' </p>
  
  <p>For example.
  <a href="https://i.stack.imgur.com/FLW8O.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FLW8O.jpg" alt="Lookup value"></a></p>
  
  <p><a href="https://i.stack.imgur.com/BY7sA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BY7sA.jpg" alt="Table Array"></a></p>
  
  <p>As you can see in the table array there are duplicate values.</p>
  
  <p>I am not sure how to use the Vlook Up here.</p>