Assign number to every value in a data range???
 

Hi guys
I'm building a sheet in where I want to store data about some web-sites
we surf in the net and could be interest for my company. So I insert a
serie of characteristic of the web-site in the colums (usability,
navigability, etc.) and in the rows an evaluation of every
characteristic from 1 to 9 . So people surf in internet and when they
find an interesting website they insert the info required to fill the
sheet. But then for every answer I would like to assign aother number
(if they say, for example, usability=1, I want assign to this value
another number, let's say 9) and see this number stored in another
sheet where then I can perform calculations. How can I do that? I tried
with =IF.. but I cannot perform that with more than 5 values...:
Thanks for your time!
The dude


--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=542551

Assign number to every value in a data range???
 

Some suggestions from a non-expert:
1. Create a list of qualifiers, eg. from "Superb" to "Extremely Bad", say
in A1:A10
2. With Data/Validation you can make a list entry referring to A1:A10; this
helps consistency and people dont have to remember what a score "4" means for
instance.
3. In B1:B10 you list the quantified score, eg B1=100, B2=85, B3=80, whatever
4. In yr new sheet you use VLOOKUP to look up the corresponding value in
B1:B10. E.g., when you have a qualifier in C12:
VLOOKUP(C12,$A$1:$B$10,2,FALSE). When you have for example in C12 "Superb"
for "Speed", the VLOOKUP returns "100" in the given example (Check the Help
file for the right use of VLOOKUP).
You can of course hide rows/columns and protect yr sheet from undesired
changes.
I hope this helps!
GL,
Henk

"the dude" wrote:


Hi guys
I'm building a sheet in where I want to store data about some web-sites
we surf in the net and could be interest for my company. So I insert a
serie of characteristic of the web-site in the colums (usability,
navigability, etc.) and in the rows an evaluation of every
characteristic from 1 to 9 . So people surf in internet and when they
find an interesting website they insert the info required to fill the
sheet. But then for every answer I would like to assign aother number
(if they say, for example, usability=1, I want assign to this value
another number, let's say 9) and see this number stored in another
sheet where then I can perform calculations. How can I do that? I tried
with =IF.. but I cannot perform that with more than 5 values...:
Thanks for your time!
The dude


--
the dude
------------------------------------------------------------------------
the dude's Profile: http://www.excelforum.com/member.php...o&userid=32838
View this thread: http://www.excelforum.com/showthread...hreadid=542551