Vlookup without sorting for duplicate lookupvalues

Vlookup in Same worksheet Example

Vlookup without sorting for duplicate lookupvalue. This is the major disadvantage. And in this case we need to use the alternative functions or need to sort the lookvalue related columns to ascending order

Vlookkup Syntax for Same working
Vlookup Example to use Named Range