Which is VLOOKUP function do you use in Excel? In C2 we will write this formula =VLOOKUP (A2:A10,B2:B10,TRUE,FALSE) and then press enter. Let`s look closely at our example for better clarification. If there exists any duplicate name, the formula will return the name from List-1.
HOW TO USE VLOOKUP IN EXCEL WITH DUPLICATE VALUES HOW TO
How to find duplicate values in Excel using VLOOKUP?
![how to use vlookup in excel with duplicate values how to use vlookup in excel with duplicate values](https://www.skyneel.com/wp-content/uploads/2015/05/How-to-Search-Duplicate-Values-using-VLookup-Function-in-MS-Excel.jpg)
To vlookup and return the certain value you need, the vlookup function will be first in your mind, but, with the vlookup function you just return the first matching value not the last. Does Vlookup return the first or last match? We can confirm if the the value is duplicated in List 1 and 2 if it returns the Value, it will be unique if it returns #NA. VLOOKUP Formula will check for the Cell B2 value in the specified Range (A2:A5) and Returns the value if found, it will return #NA if it is not found in List 1.
![how to use vlookup in excel with duplicate values how to use vlookup in excel with duplicate values](https://i.stack.imgur.com/Edn6G.png)
Why is my lookup returning the wrong value?.How do I get the last record in a Vlookup?.How do I find duplicate records in Excel?.Why is my Vlookup returning the last value?.Does Vlookup return the first or last match?.Let me know if you have any specific requirement. If you want to VLOOKUP Multiple Values with duplicate lookup values then it will not work. Note that it works only for numeric values. You can hide this Helper column or make it invisible using colours. INDEX($A$2:$A$11, MATCH (LARGE($C$2:$C$11,E2),$C$2:$C$11,0) ): Now INDEX function will look at that index in range $A$2:$A$11, and will return name at that Position. MATCH( LARGE($C$2:$C$11,E2), $C$2:$C$11,0): Match function will look for that max value in range $C$2:$C$11, and will return it’s index. LARGE($C$2:$C$11,E2): LARGE function in Excel will return the nth Largest number from range $C$2:$C$11, which will be a unique value.