Hi,
Drawback of VLOOKUP is the, first column always needs to be the LookinRange and the ReturnRange column should be always on the right, so it creates an additional works if leftside information is required, user has to manually copy paste it to the right. With the combination of INDEX and MATCH you can get the value on the left and even in the rows. Below is the command.
=INDEX("ReturnRange",MATCH("LookValue","LookInrange",True))
NOTE: The Returnrange and the LookInRange should start and end with the same Row (if looking values in a columns) and same columns (if looking values in rows)