Register now or log in to join your professional community.
Yes it is quite possible.
As per my experience, Excel2007 - The data to be searched in the range will always return the value placed at the right of the column in which data is. It will not return value placed at left.
Yes!! It is possible to get the data from left using Vlookup with other function. I did this and it is working very well.