1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Another Excel question for any Excel gurus

Discussion in 'Personal' started by anon3372, Mar 22, 2011.

  1. Can anyone, in simple terms, explain S Verweise and W Verweise to me?
    Google tells me you call them V lookup and H lookup? But I don't understand the rest.
    Obviously I want to know because I want to search for a value in one column and return a value from another column (in the row) from another table.
    Tis doing my head in!
     
  2. =vlookup(name,table array,column,false)

    Robert is yer mum's bro
     
  3. With an example

    You have a table in A1:E20

    A has names in it, C has age in it

    Then in column P you have names that you want to look up the ages for and put it in Q

    Q1=vlookup(P1,$A$1:$E$20,3,false)

    The table can be in a different sheet or even workbook
     
  4. ermmm, pardon?

     
  5. ah, ta - that makes sense!

     

Share This Page