The VLOOKUP formula searches for a value in the first column of an array and returns a value to the right of that array.
How about if you wanted to return a value to the left hand side of that array?
Well, this is where the INDEX-MATCH formula comes in and gives you a helping hand!
It searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function).
|Formula breakdown:||INDEX(array, MATCH(lookup_value, lookup_array, [match_type])|
|What it means:||INDEX(return the value/text, MATCH(from the row position of this value/text))|