Performing Vlookup on duplicate values
<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>