Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Help with a vlookup.

    Can anyone here help me i writting a vlookup function for an excel spreadsheet?

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Here's an example I put together for someone else. Hope that helps,

    Smitty
    Attached Files Attached Files

  3. #3
    Join Date
    Mar 2004
    Posts
    361
    Can you take a look at this. This is a miny version of what I am trying to do.
    Attached Files Attached Files

  4. #4
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Use this formula instead:

    =VLOOKUP(A2,Leases!A,COLUMN(),FALSE)

    EDIT: Damn smiley got in the way. Should be A : D w/o the spaces.

    Note that it would be better for recalculation to narrow the A range as right now you're forcing Excel to look through 65,536 x 2 rows.

    Hope that helps,

    Smitty

  5. #5
    Join Date
    Mar 2004
    Posts
    361
    Sweet, that worked. God I love this forum.

Posting Permissions

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