Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
What defines number or text | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
returning a text cell based on a number cell | Excel Worksheet Functions |