Vlookup with duplicates

Hello,

I am trying to do a vlookup to extract a description from a table, but it always gaves me the first result (it can has duplicated entries).

I have attached an example with explanations of what I am trying to do. I am not sure if it is possible to do it automatically...

Thank you so much in advance.

Here is one way. Please see attached.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Thanks for taking the time to comply and add to pb71 reputation .