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...