| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
display text in one cell as a number in an adjacent cell in excel
would love to get an example of the right formula, thanks
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
display text in one cell as a number in an adjacent cell in excel
Perhaps you mean something like this in say, E1:
=VLOOKUP(D1,{"Text1",10;"Text2",20;"Text3",30},2,0 ) If D1 contains: Text2, then E1 returns: 20 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Denno" wrote: would love to get an example of the right formula, thanks display text in one cell as a number in an adjacent cell in excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display a number in one cell as text in more than one cell? | Excel Discussion (Misc queries) | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
