Vlookup Syntax for same worksheet results

Vlookup in Same worksheet Example

Vlookkup Syntax for Same working would be explained what is the syntax for vlookup where we keep with in the same worksheet

Vlookup in Same worksheet Example
Vlookup without sorting for duplicate lookupvalue