Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Populating a worksheet from another w/s table (XP & 2003)

    I am attaching a workbook with 2 tabs. One tab is called 1st Half, the worksheet to be populated and the second tab is called 2nd Half, the worksheet with the data.
    I want the data in tab w/s 2nd half to populate the cells at the respective rows given the "DEPT" "Name" and respective column "month names". Is this possible to do for a 3 criterion application?

    Thank You

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Populating a worksheet from another w/s table

    I have attached a possible solution (I had to zip the file to keep it below the 100k lounge limit)

    In the "2ND HALF" sheet an extra column (col C) has been inserted that combines columns A & B (you can hide this column). On the "1ST HALF" sheet a VLOOKUP formula is then used to find the result. The VLOOKUP formula combines the values in A & B and looks up this value in the new column C of the other sheet. Hopefully it will make sense when you look at the attached file.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Populating a worksheet from another w/s table

    Thanks Tony

    Worked just fine.

Posting Permissions

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