Vlookup for duplicate values

Vlookup function with duplicate values

Vlookup function with duplicate values article explains you the way vlookup behaves with duplicate values in data