Forum Discussion
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 ...
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 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.