Results 1 to 6 of 6

Thread: Vlookup fuction

  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Vlookup fuction

    is anything wrong with this function

    =VLOOKUP(AC6,Leases!K:L,12,FALSE)

    AC6 is the unique number relative to both tables.

    K is the column of the unique number

    L is the Number I am trying to find

    12 is = to L in the alphabet.

    ????????

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Just looking at it, there's nothing wrong with it. Putting it in your spreeadsheet example from your other example it worked fine.

    What error are you getting?

    Smitty

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    If you change the Function to this

    =VLOOKUP(AC6,Leases!K:L,2,FALSE)

    this should work for you
    I just replaced 12 with 2

    Although L is the 12 letter of the alphabet you are only looking up 2
    Columns K and L so the VLOOKUP you suggested was trying to find the
    12th Column in the range K:L which dosen't Exist hence #REF! is returned.

    Hope this helps

    David

  4. #4
    Join Date
    Mar 2004
    Posts
    361
    Is it possible to look up two seperate columns while using a v lookup?

    Ex: The data is in Coloumn A and D.

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    I think not.

    You might have to do nested INDEX/MATCH functions to accomplish this.
    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

  6. #6
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    I like sumproduct - it's easier to understand than the index/match

    HTH
    texasalynn

Posting Permissions

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