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?

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?