Vlookup in second colum

Hi

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.

alring

Re: Vlookup in second colum

Hi Seti

Thank you for the help. You helped me alot there. I didn't think so long to use Index/Match. Maybe I just need a extra brain.

Again. THANK YOU