I need cells to automatically update when other cells have text inserted. I have some data on sheet 2 in columns 1 and 2. On sheet 1 when the text that matches the text on sheet 2 is entered I want the corresponding text from sheet 2 column two to be inserted. Some of my data is prefixed with '. Thanks for any help!