Forum Discussion
How to search for a common condition within two different workbooks then copy cell.
I want to create a query or formula that will check for matching data between two different workbooks and then copy data to one of the workbooks when a match is found. Ex. Workbook 1 has the foll...
Bfryar There are plenty ways to achieve this. XLOOKUP, INDEX/MATCH or Power Query.
I would favour Power Query for these type of tasks (especially when the data sets become large and complex) as it leaves the raw data untouched and you avoid having to write moderately complex formulae. But that's just a personal preference.
The attached workbook contains all three. Depending on your Excel version, the XLOOKUP option might not work. And if you are on a Mac, you may skip the Power Query option.