This articles would be clear your doubt on Vlookup with duplicate values with details explanation. Vlookup can provide many variety of results.
Usually Vlookup would be used to search right side values in the data using left side value. Here left side value as key to search the corresponding same value related right side value.
When we have duplicate key values or right side values. Vlookup function returns you first occurrence of the value. Please find below image to understand in more detailed
If you see the above image, Trump name is there twice and formula written for Trump’s values. Since it is there for twice. It is returning first instance related value. Usually in this case Vlookup does not fit to pull details. If you get as such requirement, you need to slightly modify the vlookup functionality using user defined functions. Sometimes we get requirement to pull all details of key value. This is very rare case. Still we need to know the way how we have to do that. Stay tuned, I will provide you the way how we can create to pull all the duplicate values for key value in vlookup. Hope you understand vlookup behavior with duplicate values