A major drawback of VLOOKUP is the, first column always needs to be the “LookInRange” and the “ReturnRange” column should be always to the right. This creates additional works if information to the left of the “LookInRange” is required; the user has to manually copy and 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))