Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 25th 05, 06:49 AM
jwmaes
 
Posts: n/a
Default how can text be set up to generate a number?

i would like to a word generate a number, i.e. enter "apples"in one cell and
excel generate "352" in a different cell for items like inventory.

  #2   Report Post  
Old January 25th 05, 07:53 AM
Nick Hodge
 
Posts: n/a
Default

Basically

You will need to set up a 'Lookup' table somewhere with

Apples 352

In two columns. Complete this for all entries and then if you are going to
enter 'Apples' on another sheet in A1 then in A2 enter

=VLOOKUP(A1,Your_Lookup_Range_Address,2,FALSE)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"jwmaes" wrote in message
...
i would like to a word generate a number, i.e. enter "apples"in one cell
and
excel generate "352" in a different cell for items like inventory.



  #3   Report Post  
Old January 25th 05, 07:56 AM
Ron de Bruin
 
Posts: n/a
Default

Hi jwmaes

You can use Vlookup

Make a list in a other sheets with the text and the number in the column next to it.
And use this list in your Vlookup formula

See the Excel help for examples


--
Regards Ron de Bruin
http://www.rondebruin.nl



"jwmaes" wrote in message ...
i would like to a word generate a number, i.e. enter "apples"in one cell and
excel generate "352" in a different cell for items like inventory.



  #4   Report Post  
Old January 25th 05, 01:32 PM
Debra Dalgleish
 
Posts: n/a
Default

As Ron and Nick suggested, you can use a VLOOKUP formula to return the
number. There are instructions and examples here that may help you get
started:

http://www.contextures.com/xlFunctions02.html

jwmaes wrote:
i would like to a word generate a number, i.e. enter "apples"in one cell and
excel generate "352" in a different cell for items like inventory.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Defining a number in a cell by text then subtracting it by the tex Crowraine Excel Worksheet Functions 1 December 16th 04 07:49 AM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM
What defines number or text Danny J New Users to Excel 3 December 7th 04 07:27 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
returning a text cell based on a number cell Josh7777777 Excel Worksheet Functions 2 November 2nd 04 07:42 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017