'How to transfer contents from a excel sheet to send another. Both sheets have relational data but need to transfer the phone number based on same name

The two sheets have similar information but one of the sheets is missing the phone number of the employees. So I need to create a formula that transfers the number over based on both sheets having the same name in the row.



Sources

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

Source: Stack Overflow

Solution Source