Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
Is there a formula that I can use to automatically put in a number in one
cell if I type a specific text in another cell. Example: If I type the word Melrose Park IL in one column can I use a formula that will automatically put in 2.10 into another column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
Do you have other text linked to other numbers?
If so then you could use VLOOKUP. E.g list the text in one column, e.g. in D1:D10 list "Melrose Place IL" and whatever other text you might have. In corresponding rows in E1:E10 put your numbers, e.g. in E1 2.10 then assuming you type text into A1 and want the number to appear in B1, use this formula in B1 =VLOOKUP(A1,D1:E10,2,0) "hoopstrk" wrote: Is there a formula that I can use to automatically put in a number in one cell if I type a specific text in another cell. Example: If I type the word Melrose Park IL in one column can I use a formula that will automatically put in 2.10 into another column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|