How to reverse the VLOOKUP range?
How to reverse the VLOOKUP range?
The core principle of VLOOKUP is the value that we are looking for should be in the first column of the range.
And the returned value should be at the right of the first column in the range.
Is it possible to return a value located at the left?
To achieve that, we create a virtual table using the array.