Forum Discussion

ethinix's avatar
ethinix
Copper Contributor
Nov 11, 2023
Solved

Match Column A of One Excel File with Column A of another Excel File and copy Data

Hello Community, Please help me out with this. I have two Excel files. I want to match Column A of one file with Column A of another file. If both are same, I want to copy data in Columns B,C,D,E o...
Excel for web
office 365
Office Scripts
  • Lorenzo's avatar
    Lorenzo
    Nov 11, 2023

    Hi ethinix 

     

    Assuming your 2nd file has a header (as below) in row 1 and the values you want to match (in your 1st file) start in row 2:

     


    in B2 of your 2nd file:

    =XLOOKUP(A2, 'File 1'!A:A, 'File 1'!B:E, "No match")


    Sample attached ('File 1' and 'File 2' are in the same workbook for simplicity)

ethinix's avatar
ethinix
Copper Contributor
Nov 11, 2023
Thank you so much. It worked.

Resources