Forum Discussion

JakesWork's avatar
JakesWork
Copper Contributor
Sep 12, 2023

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.

  • 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.

Resources