Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to value
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to value
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 "Brian" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to value
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? "Chip Pearson" wrote: 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 "Brian" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |