Text and numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

On Tue, 19 Oct 2004 09:27:03 -0700, "Pepper Sue" <Pepper
 
Back
Top