Alternative of vlookup or proper adaptation
Posted on 2011-05-10
I'm using the following formula:
The functionality of VLOOKUP is ok but in this very case I have an issue with it because C3 is located in the B column and value to lookup is located in the A column.
To have vlookup working I just would need to move the A column to the B column and B to A but let's presume that this is for other reason is not possible.
So how Vlookup can or must be adapted to search for a value one column before and not after the main column?
I tried with INDEX and MATCH but could not figure it out.
With other words: The C3 values can be found in the B column of the other file and the respective return value needed is located in the A column which can not be moved.