Results 1 to 3 of 3

Thread: lookup help

  1. #1
    Join Date
    Aug 2004
    Posts
    178

    Unanswered: lookup help

    i dont use excel that mush what i am trying to do lookup a colum a1:a:20 in another sheet2 b2:b:20 and bring up the result of sheet2 colum c2:c20.
    which is not a problem but in my list i am looking up i have more then whats in sheet2 and i want it to return 0.

    lookup

    a
    b
    c
    d
    e

    sheet2

    a 20
    b 22
    d 34
    e 36

    i keep getting my result as

    a 20
    b 22
    c 22
    d 34
    e 36

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. What formula are you using? Can you provide exactly what it is? It probably is either a wrong last element or a missing last element.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Look at the VLOOKUP() function in the Help. It's your ticket.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •