Hey folks,
I know how to use VLOOKUP, but how do I use it the other way around. I want to look in a range of cells in the rightmost column, and when I find the thing I want, to return the value in the left most column. Sort of VLOOKUP reversed.
Can anyone help me?
I know how to use VLOOKUP, but how do I use it the other way around. I want to look in a range of cells in the rightmost column, and when I find the thing I want, to return the value in the left most column. Sort of VLOOKUP reversed.
Can anyone help me?