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?