Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Michigan, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Get value from cell range (2000)

    Hi, thanks for reading! I have 4 columns: Beginner, Intermediate, Advanced, Expert. A user places an X in one of the 4 columns, either Beginner, Intermediate, Advanced, Expert.

    Is there a function that returns a numeric value equal to the column they put an x in? For example, if they x beginner, the value returned is a 1. If they x intermediate, the value returns a 2. Perhaps equation wise, it may look something like this???

    =FINDVAL(A1:A4),"x"

    THANKS for any suggestions or tips, I'm stumped on this so far.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get value from cell range (2000)

    Your text said columns, but your example looked like rows. I will assume you meant columns since that makes more sense. If the columns are A11, then try this formula:

    <pre>=MATCH("x",A11,0)
    </pre>

    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Get value from cell range (2000)

    Say that row 1 contains the labels Beginner, etc. in columns A - D.
    The user places an "x" in one of the cells A22.
    In cell E2, put this formula:

    =MATCH("x",A22,0)

    You can fill down to rows below if appropriate.

  4. #4
    New Lounger
    Join Date
    Sep 2003
    Location
    Winnipeg, Manitoba, Canada
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get value from cell range (2000)

    Steve,

    You could try a formula with some nested if's. Kinda like this ...

    =IF(A2<>"",1,IF(B2<>"",2,IF(C2<>"",3,IF(D2<>"",4," "))))

    This equation will look for any thing in one of the columns not just an x. If there is nothing in the columns the value is blank. If there is more than one column selected you get the value of the first column with a value in it.

    I'm not sure how the more experienced Excel people would do it but it seems to work.

    Hope that helps.

    Wes

  5. #5
    Star Lounger
    Join Date
    Aug 2002
    Location
    Michigan, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Get value from cell range (2000)

    MATCH! That function is absolutely perfect, and does just what I need it to do! Thank you ALL very, very much for your help, I greatly appreciate it!!!!

Posting Permissions

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