| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I give text (A,B...) a number value in Excel (A=1, B=2..)
=VLOOKUP(text,A:B,2,0)
Where text is your word (or cell address of text) columns A & B contain your word to number table A B HIGH 3 MEDIUM 2 LOW 1 etc HTH "Pete" wrote: I'm trying to give a word/text a numeric value. High = 3, Medium = 2 and Low = 1 etc. I thought this could be done with a lookup table? If anyone has any information on how to do this I'd be most appreciative. Cheers, Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel give value in words of number entered in another cell? | Excel Worksheet Functions | |||
| function to give the number of hours | Excel Worksheet Functions | |||
| The same IF (SE) formula give me two different number: why??? | Excel Worksheet Functions | |||
| Are you able to give a letter a number value | Excel Discussion (Misc queries) | |||
| Minutes multiplied by a number to give a number | Excel Discussion (Misc queries) | |||
Hybrid Mode
