Text to value

B

Brian

Hello all. I want to relate text to a numerical value. For example the word
"Car" is equal to 4 points, the word "Phone" is equal to 2 points, the word
"Talk" is equal to 5 points and so on at one time then add and give me a
total of points. Is this to complex for Excel, if not what is a possible
function? Thanks
 
C

Chip Pearson

Brian,

The easiest way would be to use a VLOOKUP function. Create a
table in some unused cells, say Y1:Z10, listing the words in one
column and the respective values in the second column. Then, use
the following formula:

=VLOOKUP(A1,Y1:Z10,2,FALSE)

See help for VLOOKUP for more info.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Brian

I think I'm confused. I have a table already set up. I want to find the word
"robbery" and relate that this is 4 points then continue adding points for
other particular words until finished. All my data is in a merged cell in
list format. I want to find the words, then add there related values, then
place the result in a predetermined field in my spreadsheet. Any solutions?
 
Top