# Thread: Get value from cell range (2000)

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

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