+ Reply to Thread
Results 1 to 2 of 2

Reading from a particular page based on drop list option

  1. #1
    Registered User
    Join Date
    05-31-2007
    Posts
    17

    Reading from a particular page based on drop list option

    Hi,

    I am working on a new fixturing system for a Sports Competition.

    I have 4 worksheets which are named "5 team fixture", "6 team fixture", "7 team fixture" etc

    Each worksheet simply looks like this:

    1 | 2
    3 | 4
    5 | Bye
    2 | 4
    1 | 5
    3 | Bye

    ...etc...

    On a 5th worksheet "FixtureOptions" I have:
    1 | 5 Team Fixture | 5Team (this is the name of the worksheet where this fixture can be found)
    2 | 6 Team Fixture | 6Team
    3 | 7 Team Fixture | 7Team

    ...etc...

    On a 6th worksheet "ShowFixture" up the top I have a drop list. This lists shows the 4 different fixture names that can be selected which returns 1 through to 4.

    From here I want to lookup the worksheet, and then input into the 6th worksheet the numbers of each game.

    It's calling on the worksheet I am unsure of. All my limited knowledge comes up with is in each cell having:

    =if(B2=1,'5Team'!A1,if(B2=2,'6Team'!A1... etc

    But obviously this is a stupid way of doing it lol - I think I should be able to somehow do:

    ='NAMEOFWORKSHEET'!A1 but not sure how to lookup and insert name into formula.

    Any help in the right direction would be much appreciated! I have attached an example workbook.
    Attached Files Attached Files
    Last edited by Taylor_1978; 04-22-2009 at 10:04 PM.

  2. #2
    Registered User
    Join Date
    05-31-2007
    Posts
    17

    Re: Reading from a particular page based on drop list option

    I solved this myself. All it took was lookup sheet name from FixtureOptions and do an indirect:

    =INDIRECT(G2&"!A1")

    I should have googled this before posting here! Sorry!

+ 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