Forum Discussion
JakesWork
Sep 12, 2023Copper Contributor
Vlookup Formula
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.
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.