Vlookup Formula

[JakesWork]

In Excel, I have two sheets in one document. Both sheets have a list of our user's names in column A. I need to know how to set up a formula that checks the names in column A for both sheets and if that name is in both, it will add the phone number associated with the name in column B sheet 2, to column B in sheet A. That way we can update our records.

[#2]

@JakesWork 

In B2:

=XLOOKUP(A2, 'Other Sheet'!$A:$A, 'Other Sheet'!$B:$B, "")

or if you do not have Microsoft 365 or Office 2021:

=IFERROR(VLOOKUP(A2, 'Other Sheet'!$A:$B, 2, FALSE), "")

Replace Other Sheet with the actual name of the sheet that already contains the phone numbers, then fill down.