Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Lookup Data from a separate sheet

  1. #1
    Join Date
    26th July 2006
    Posts
    10

    Lookup Data from a separate sheet

    Hi Ozgrid Community.

    Please could someone assist me on the following spreadsheet?

    I have a spreadsheet that has a resource table, project stage table and an approx 50 different project sheets. (The 50 sheets are duplicated layouts, just different project names)

    Based on the data on the first two sheets I would like to populate the individual project sheet.

    For example:

    1. In the individual project sheet there are 5 stages in each quarter.
    2. The project stage table sheet tells you want stage the individual project is in for the relevant quarters.
    3. The resource table sheet tells you how many resources are required for that stage.

    Based on this information, I would like to populate the individual project sheet with the information.

    E.g. If the project is in the 1st stage, it would then go to the resource table and take number of resources allocated for that stage and populate the “relevant” field in the individual project sheet with the correct value.

    I've attached the spreadsheet to hopefully better illustrate this.

    Could someone please please please help me?

    Thank you
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    11th March 2005
    Location
    Los Angeles
    Posts
    500

    Re: Lookup Data from a separate sheet

    Ahhhh. Project management. I pity you. I have done this......... Reporting on projects is, um, thankless at the very least. My advice: stop wasting your time and buy one of the great off the shelf project reporting packages available EVERYWHERE. I REALLY mean this. Do yourself a favor. Pay for it with your own money if you have to. It is worth every dime.

    But, I think you are looking for the index, lookup and match functions. Are you familiar with them?
    Last edited by fengore; August 29th, 2006 at 22:45.
    Eternity is a terrible thought. I mean, where's it going to end??

  3. #3
    Join Date
    26th July 2006
    Posts
    10

    Re: Lookup Data from a separate sheet

    Hi I know it's a bit of a mission!!!!!!!!!
    I am familiar to a certain degree with those functions, however i'm not sure how to use them in this situation.

    Any suggestions?

    Thanks for the reply!

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    10th August 2005
    Posts
    844

    Re: Lookup Data from a separate sheet

    Is there any logic/pattern to the group numbers? Can a project move from one group to another over time or is it always in the original group that it is assigned?

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    9th June 2006
    Location
    The best city, in the best state, in the best country, in the known inhabited universe, Houston, TX
    Posts
    966

    Re: Lookup Data from a separate sheet

    BVic,

    I may be able to sort through this with you but, you got to help a little more. For instance, what are the correct values in your example? Can at least the designation for quarters be standardized (pick either Q1 or 1Q)?

    Please post a more complete example with your expected results so we don't have to make so many guesses and I'm sure someone will help you.

    Jim

    PS-Fengore is right....

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    11th March 2005
    Location
    Los Angeles
    Posts
    500

    Re: Lookup Data from a separate sheet

    Some Samples to start you off
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Eternity is a terrible thought. I mean, where's it going to end??

  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,714

    Re: Lookup Data from a separate sheet

    Not the answer you would like no doubt, but you are uisng Excel completely wrong. See The Number 1 Mistake Made By Excel Spreadsheet Users

    A little bit of pain now will stop a lifetime of grief.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Apply Data Validation List From Separate Sheet
    By dal156 in forum EXCEL HELP
    Replies: 1
    Last Post: May 29th, 2008, 10:28
  2. Lookup 2 Values In Separate Sheets To Find A Third
    By Treefern in forum EXCEL HELP
    Replies: 2
    Last Post: March 3rd, 2008, 07:30
  3. Lookup Data On Another Sheet
    By globalStar in forum EXCEL HELP
    Replies: 4
    Last Post: June 27th, 2007, 15:29
  4. Replies: 6
    Last Post: May 4th, 2006, 17:07
  5. Replies: 3
    Last Post: March 15th, 2003, 07:41

Bookmarks

Posting Permissions

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