Text and numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pepper Sue - 19 Oct 2004 17:27 GMT

I'm working on a job applicant scoring system. I would like for any text
that I type to represent a number value that I choose, so that I can score
applicants.

Reply to this Message

Peo Sjoblom - 19 Oct 2004 18:15 GMT

Create a vlookup table

a 5
b 4
c 3
d 2
e 1

assume the range is

Sheet2!$A$2:$B$6

then use a formula like

=VLOOKUP(A2,Sheet2!$A$2:$B$6,2,0)

where A2 would be a cell where you type for instance
"c" which will return the score 3

Regards,

Peo Sjoblom

> I'm working on a job applicant scoring system. I would like for any text
> that I type to represent a number value that I choose, so that I can score
> applicants.

Reply to this Message

Gord Dibben - 19 Oct 2004 20:51 GMT

Sue

From Peo Sjoblom....
=IF(A1="","",VLOOKUP(A1,{0,"F";0.6,"D";0.7,"C";0.8,"B";0.9,"A"},2))

From Jason Morin......
=LOOKUP(A1*100,{0,60,70,80,90},{"F","D","C","B","A"})

Adjust ranges of numbers to letters to suit.

Gord Dibben Excel MVP

>I'm working on a job applicant scoring system. I would like for any text
>that I type to represent a number value that I choose, so that I can score
>applicants.

Reply to this Message