Code to search

Hi Guys,

Can you help me on this I need a code or formula that will search data on 1st column based from the Lookup list (3rd column). If it will find the word it will replace based from the lookup data. New Data or Outcome is on the 2nd column.

Original Data	New Data	Lookup
AC COOL BROTHERS	AC COOL BROTHERS INC	AC COOL BROTHERS INC
A TEAM UNITED INC	A TEAM UNITED INC	AASONN UNITED INC
AF PAYMENT INC	AF PAYMENT INC	AB TEAM EXPONENT INC.
AB TEAM	AB TEAM EXPONENT INC.	XYZ LEARNING COMPANY
AASONN	AASONN UNITED INC
AC COOL	AC COOL BROTHERS INC
ADD RESEARCH PAINTS AND CHEMICALS	ADD RESEARCH PAINTS AND CHEMICALS
XYZ LEARNING	XYZ LEARNING