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.


  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!