Forum Discussion
XLOOKUP HELP IN EXCEL
bcook02 Difficult to visualise how your data is structured exactly, but you may want to look into the FILTER function in stead. Otherwise, upload a representative samples of your workbooks (eliminate any private or confidential information), noting which data should be shown where.
I hope this helps explain things better. I export the data daily into Excel for various orders. What I am needing to do is transfer the comments from Workbook1 to Workbook 2 properly. I can reference the order number in the XLOOKUP but this won't necessarily transfer the comments properly because there may be more than one comment for each order #.
Example:
Order #124 has 3 comments because of the different part numbers but I need to transfer the comments based on the Order#, PO Item & Scheduled Quantity, not solely just based on the order number.
bcook02 Have a look at the attached simplified example. It demonstrates how you can join two lookup elements to create unique lookup values. Perhaps you can apply it to your own schedule.
Thank you for that simplified XLOOKUP version. How would this be coded to pull data from one Excel file to another?
