Forum Discussion
how to match the list data from different excel sheets
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
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
Thank you this has solved my problem. If I have two worksheets in same workbook, and I am comparing sales orders from previous quarter and see how many new orders are available. Can I still use XLOOKUP or VLOOKUP for that data? Due to work rules, I am unable to post the actual worksheets.
- Maybe, or maybe a COUNTIFS. I'd suggest posting a new thread. I'm signing off for today
Suggested solution attached
XLOOKUP is not backwards compatible with older versions of Excel
