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

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Sep 06, 2020

Krishck 

Why not upload a sample Excel file instead of image as images are difficult to work with?

Krishck's avatar
Krishck
Copper Contributor
Sep 06, 2020

Subodh_Tiwari_sktneer Hi thank you for response. I have uploaded the file. It would be great if there's anyway to work using formulae or any insight for future, when I am working with thousands of rows. As that will help me a lot for future reference.  

Resources