Recognizing text RRS feed

  • Question

  • In Excel or other software, is there any way in 2 linked worksheets, if every time a particular string of text appeared in one worksheet, the computer would recognize this and put a corresponding text into the linked document.  For example, in a menu (Excel) for every time there was Chocolate Milk, I would like 2% Milk to appear on a diabetic menu.  Can anyone help me do something like this?

    Monday, October 19, 2009 7:53 PM