Results 1 to 8 of 8

variable lookup and select 4

Threaded View

  1. #1
    Registered User
    Join Date
    11-25-2010
    Location
    North Pole, Alaska
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question variable lookup and select 4

    I have searched Google to the ends of the net and have not found anything close to a solution for this. Perhaps someone here can point me in the right direction.

    OK, I have several rows with a radio button in the first column, when selected, the linked field displays a number.

    On the columns, above the header, is a checkbox.

    The plan of operation is this:

    The user clicks a row indicating a player, then selects up to 4 checkboxes at the top for export to a stats screen.

    I got the row working, and got the first checkbox to display the selected statistic, but the second stat line still only shows the first checkbox selected.

    Example time (hopefully):
    | A | B | C | D | E
    1 | | [] | [] | [] | []
    2 | O | plr1 | 1 | .2 | 15
    3 | O | plr2 | 2 | .35 | 12
    4 | O | plr3 | 3 | .1 | 17
    5 | O | plr4 | 4 | .275 | 5
    6 | O | plr5 | 5 | .4 | 10

    A B
    10 Name
    11 Stat1
    12 Stat2
    13 Stat3

    There are actually 14 stats that could be selected, but this shoudl be enough.

    When a row is selected via the radio button, eg row 3, then A1 will display 2. I use this with a INDIRECT function INDIRECT("B"&A1) which will display plr2 in B10.

    When a column checkbox is selected, say C, which is bound to C1 as True/False, then B11 is determined by IF(C1=TRUE, INDIRECT("C"&A1),"") which in our case would be "2"

    Still with me? I hope so, I NEED you!

    If B1 is checked, I need THAT to take over stat1, and Stat2 to reflect the selected C1 stat. Instead, both stat1 and 2 will display B1's stats.

    Now to be able to do this for up to 4 stats!

    Anyone able to assist me? Or better yet, point me in a better direction to solving this problem?

    Thanks for the time and assistance.

    Jon
    Last edited by akscooter; 12-01-2010 at 01:10 PM.

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