excel-university.com
How to Return a Value Left of VLOOKUP’s Lookup Column
If you have ever tried to return a value that physically lies to the left of the lookup column, you quickly realize that this task is difficult to accomplish with the VLOOKUP function. This is a p…