display text in one cell as a number in an adjacent cell in excel

's Computer Specifications

would love to get an example of the right formula, thanks

's Computer Specifications

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
Re: display text in one cell as a number in an adjacent cell in excel

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
display contents of cell if adjacent cell equals	Travis	Microsoft Excel Worksheet Functions	1	7th Jun 2008 02:34 PM
Total based on text dependancy + number value in adjacent cell	EAE	Microsoft Excel Misc	4	24th Jan 2008 04:31 PM
Automate adding in a reference number if the adjacent cell contains text...	mg	Microsoft Excel Worksheet Functions	1	24th Jan 2008 01:16 AM
have one cell display text which reflects a number in another cell	=?Utf-8?B?ZXhjZWxyb29raWU=?=	Microsoft Excel Misc	3	25th Sep 2006 05:49 PM
display a number in one cell as text in more than one cell?	=?Utf-8?B?U3Rvcm0=?=	Microsoft Excel Misc	6	6th Jul 2006 03:08 PM