Need help giving a response a number value

C

ConfusedatWork

I am trying to set up a new tracking system for our Patient Satisfacion cards
to be used in evaluation staff. I have a system now where I simply plug in
the information into Excel and when it is time for a yearly review, I simply
sort by Physical Therapist. I would like to know if there is a way to give
each response a number value and set up seperate sheets for each Physical
Therapist. Basically I want to enter Excellent on the tracking sheet...but
for that Excellent response...give the Physical Therapist 5 points. Good = 4
points, Okay = 3 points and so on. Is this possible? If so, how the world do
I do it? Thank you so so much for any help. I feel I am pretty good with
Excel so if someone could give me some good directions, I am sure I could
figure it out.
 
S

Shane Devenshire

Hi,

I would use VLOOKUP after creating a little table of your possible results
and their numerical equivalents.

=VLOOKUP(A1,C$1:D$5,2,)

where A1 contains the result "Excellent" or whatever and C1:D5 is your
lookup table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Real Data Formatting Challenge 3
Help needed to find a formula 4
need help with report and pretty much everything. 1
Export and Save Only Certain Rows of Data 1
Ecount on filtered records 1
Giving "X" a numerical value. 7
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
giving points by a result (function) 2

Top