Forum Discussion
XLOOKUP HELP IN EXCEL
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?
bcook02 If you have both workbooks open, you should be able to just follow all the steps and click between the workbooks to insert the lookup ranges and the return ranges. All I wanted to demonstrate is that you can use the &-sign to combine lookup values and lookup ranges.
Thank you for your assistance!