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!


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=559849