suppose on one sheet in col.A there are names,and againt them o.e in clumn B
there are values,if we want to pickup the values against names we use
vlookup, but what to do if the same is reversed, that means the values are in
cloumn B and names are in column A