If The Search Column For A Vlookup Contains A Duplicate Value

0
Vlookup for duplicate values

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 correspending same value related right side value.

When we have duplicate key values or right side values. Vlookup function returns you first occurance 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 behaviour with duplicate values

 

 

 

 

Summary
If The Search Column For A Vlookup Contains A Duplicate Value
Article Name
If The Search Column For A Vlookup Contains A Duplicate Value
Description
If we get a requirement to pull values using vlookup where as search values with duplicates. This article can help you to understand the way of vlookup behaves
Author
Publisher Name
Excel-Formula
Publisher Logo

LEAVE A REPLY

Please enter your comment!
Please enter your name here