Normal when I use vLookup then the value I lookup is in the first colum. Is it possible that the value I use to lookup with is in the second colum instead of the first?
Another problem to this that I also need the result from the first colum.
I have attached an exsample. On sheet2 is the table array.
On sheet1 is it cell A2 I want to lookup in the table array.