Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    moving info (xp)

    I have a small problem
    On page (sheet1) I have information which I get from a web query
    On page (sheet2) is a list of all the different things I am tracking

    what I want to do is go down Column "B" of (sheet1) and every time It finds something that matches something in Column "C" of (sheet2) then take the contents of Column "F" of (sheet1) and place it in column "A" (sheet2) beside the matching value. I am thinking that this might be a vlookup but I am still new to vb in excel.

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

    Re: moving info (xp)

    Assuming that row 1 contains headers, enter the following formula in cell A2 on Sheet2:
    =IF(ISNA(VLOOKUP(C2,Sheet1!$B$2:$F$1000,5,FALSE)), "",VLOOKUP(C2,Sheet1!$B$2:$F$1000,5,FALSE))
    Adjust the range B2:F1000 as needed.

    BTW, could you edit your signature? A signature is supposed to be 3 lines high at most, yours is 8 lines high. Thanks!

  3. #3
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: moving info (xp)

    HansV

    again you are a wizard..... thanks.

Posting Permissions

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