Forum Discussion
XLOOKUP HELP IN EXCEL
I have a problem in which I am in need of some assistance. I am trying to merge information from 2 workbooks together. Here is what I need: Take a column of comments pertaining to order inform...
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!