Announcement

Collapse
No announcement yet.

Lookup Data from a separate sheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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, 22:45.
    Eternity is a terrible thought. I mean, where's it going to end??

    Comment


    • #3
      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!

      Comment


      • #4
        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?
        ---
        Old Programmers Never Die ... They just lose their bits

        Comment


        • #5
          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....

          Comment


          • #6
            Re: Lookup Data from a separate sheet

            Some Samples to start you off
            Attached Files
            Eternity is a terrible thought. I mean, where's it going to end??

            Comment


            • #7
              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.

              Comment

              Working...
              X