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

Asked Mar 06 '22 at 02:40

Active Mar 06 '22 at 02:40

Viewed 33 times

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.

asked Mar 06 '22 at 02:40

Brian Figueroa

Index() and match(), many examples exist on here. – Solar Mike Mar 06 '22 at 06:33
2

Vlookup, Index/Match, Xlookup all these functions will do that. – Harun24hr Mar 06 '22 at 06:54
2

Check [this](https://stackoverflow.com/a/71332598) out. – VBasic2008 Mar 06 '22 at 08:16

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

0 Answers0