Vlookup Formula

Copper Contributor

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.

1 Reply


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.