Vlookup searches from Left to right vertically column wise

Vlookup in Same worksheet Example

Vlookup searches from Left to right vertically column wise to get the exact values in to the desired cells

Vlookup Tutorial