could any one please explain me the difference between vlookup and Index and when I can we use that ?

could any one please explain me the difference between if condition and conditional formatting ?