Forum Discussion

Krishck's avatar
Krishck
Copper Contributor
Sep 06, 2020
Solved

how to match the list data from different excel sheets

Hi, I am new to excel and I looked everywhere for the following Q&A but I couldn't find any, unless I missed smh. I have list data and I want to place a result for certain match  Fig.1 data is ...
excel
Formulas and Functions
office 365
  • Wyn Hopkins's avatar
    Wyn Hopkins
    Sep 06, 2020

    Hi Krishck

     

    If you want to get the result value from the table sheet into the Sales Orders sheet then if you have XLOOKUP you can type this into cell D2 of the Sales Order Sheet

     

    =XLOOKUP(B2&C2, table!$A$2:$A$12 & table!$B$2:$B$12, table!$C$2:$C$12)

    My other tip would be turn the table of lookup values on the table sheet into a proper Table by clicking in the data and pressing Ctrl t before you then add the formula

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Sep 06, 2020

Hi Krishck

 

If you want to get the result value from the table sheet into the Sales Orders sheet then if you have XLOOKUP you can type this into cell D2 of the Sales Order Sheet

 

=XLOOKUP(B2&C2, table!$A$2:$A$12 & table!$B$2:$B$12, table!$C$2:$C$12)

My other tip would be turn the table of lookup values on the table sheet into a proper Table by clicking in the data and pressing Ctrl t before you then add the formula

Resources