Forum Discussion
learningexcel
Jun 29, 2019Copper Contributor
Limitations Of VLOOKUP!
Hi all, just learnt the correct ways of applying the Vlookup. Applied it to a set of data, just to practice and check the authenticity and cross verify. Feel that the function is not working fine...
SergeiBaklan
Jul 01, 2019Diamond Contributor
VLOOKUP returns first found value in the range. To receive Nth match there are other techniques like here https://trumpexcel.com/lookup-second-value/