'If column "a" in sheet1 matches column "a" in sheet2 then replace entire row in sheet1

I would like to compare column A in sheet1 to column A in sheet2.

If the values match, copy data from sheet2 into sheet1 into the row that matches values.

Example:
enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source