Auto fill cell based upon another cell value

[Shek5150]

Thanks in advance for your help.

I'd like to be able to do the following:

Cell A1 would received a value (manually entered) of 1-19 and base upon that
value... cell B1 would yield a corresponding percentile.

For example:

If the user were to enter a scaled score of 9 (into cell A1) then the
percentile 37% would be autofilled in cell B1.

note: I have 19 scaled scores that have corresponding percentiles...I've
tried to copy (and alter) a code that I thougt would work...but it went kaput.

Again, thanks in advance for any help w/ this issue.

Steve

 

[Mike H]

Hi,

You need a lookup table like the one below (i guessed the percentages) mine
is in e1 - F19 but it could be anywhere out of the way. Then the formula

=VLOOKUP(A1,E1:F19,2,FALSE)

1 2
2 7
3 13
4 18
5 24
6 29
7 35
8 40
9 46
10 51
11 56
12 62
13 67
14 73
15 78
16 84
17 89
18 95
19 100

Mike

 

[JMay]

=CHOOSE(A1,0.1,0.2,0.3,0.4) << Choose can have up to 29 arguments (format as
%)

 

[Shek5150]

Thanks Mike H...that did the job...

Steve

Hi,

You need a lookup table like the one below (i guessed the percentages) mine
is in e1 - F19 but it could be anywhere out of the way. Then the formula

=VLOOKUP(A1,E1:F19,2,FALSE)

1 2
2 7
3 13
4 18
5 24
6 29
7 35
8 40
9 46
10 51
11 56
12 62
13 67
14 73
15 78
16 84
17 89
18 95
19 100

Mike