Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup formula (2003 SP3)

    There appears to be an error in your link.

  2. #2
    Lounger
    Join Date
    Jan 2008
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup formula (2003 SP3)

    I am new at lookup formulas and need help figuring out how to match the two sheets on the zip file (150k) located at the link below.

    http://www.filedropper.com/danapointapnaccount_1 (hit the download button)

    What I would like is if the account numbers match on Sheet 1 and 2, then the consumption data from sheet 2 gets transferred to sheet 1. Hopefully makes sense. Thank you.

  3. #3
    Lounger
    Join Date
    Jan 2008
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup formula (2003 SP3)

    I just checked and it worked fine for me. I added the 'hit download button' information above. Thank you.

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup formula (2003 SP3)

    In D2, you can use =VLOOKUP(A2,Consumption!A:B,2,FALSE)

    The link works in explorer, but not in google.

    HTH.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup formula (2003 SP3)

    Welcome to Woody's Lounge!

    You can use VLOOKUP for this. The basic formula is

    =VLOOKUP(A2,Consumption!$A$2:$B$6560,2,0)

    in D2. However, this will return #N/A if there is no match. To suppress this, you can use

    =IF(ISNA(VLOOKUP(A2,Consumption!$A$2:$B$6560,2,0)) ,"",VLOOKUP(A2,Consumption!$A$2:$B$6560,2,0))

    You can fill down from D2 to the end of the table.

    Note: it isn't necessary to supply a huge workbook with thousands of rows. A reduced sample file with a very limited number of rows is easier to attach and to handle. So in the future please take a few minutes to create a small workbook that can be attached directly to a post. Thank you in advance.

Posting Permissions

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