+ Reply to Thread
Results 1 to 5 of 5

Indirect address/match

  1. #1
    Registered User
    Join Date
    03-28-2007
    Posts
    71

    Indirect address/match

    Hi,

    I am trying to do season stats for my roller derby league. I have a great spreadsheet going but the one thing I want to do, I can't seem to do.

    I am attaching a "test" file. very simple and small but shows what I need to do.

    I have different sections and I am trying to pull the highest number out of that section. For this example, it is under the green Jams Skated: Jams at Jammer. The number on the right is the highest number of jams skated while the number on the left should be the name of the skater who has this number. Okay, no problems there.

    My problem occurs when I try to move these same formulas to another sheet. in this case, sheet 2. It pulls all kinds of strange things.

    How do I fix this?

    Thanks for any help you can give me.
    Attached Files Attached Files
    Last edited by Prcntrygrl; 08-26-2009 at 05:05 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: Indirect address/match

    On Sheet2, preceed your "Address" with "Sheet1!" like so
    Please Login or Register  to view this content.
    Is that what you needed?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    03-28-2007
    Posts
    71

    Re: Indirect address/match

    so simple and I never would have figured that out.

    Thank you sooo much

    Chris

  4. #4
    Registered User
    Join Date
    03-28-2007
    Posts
    71

    Re: Indirect address/match - one more thing.....

    So, you totally Rock!! One more question. What if I want to pull this number for the max only by Team?

  5. #5
    Registered User
    Join Date
    03-28-2007
    Posts
    71

    Re: Indirect address/match

    Nevermind. I figured it out myself.

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1