VLOOKUP cannot go Left…
Vlookup can help us if we have “Name of the student” & we want to have his “CTC”. Not the other way around [ Eg if we have the CTC of 470000, V lookup cannot tell us that this CTC is for Sriparna Ghosh
This is because, once we search a list using VLOOKUP, you can only return corresponding items from column at right, not at left.
Solution is the formula called Index + Match. The basic syntax of this combination is like this:
=INDEX (column with data you want,MATCH(value you are looking for, column which contains this data,0)).