Forum Discussion
promedicakelly
Jun 28, 2023Copper Contributor
XLOOKUP/ Adding in Duplicates
I have two spreadsheets I am trying to combine. Spreadsheet A has Procedural data and Spreadsheet B has Follow Up data. I need to move the follow up data from Spreadsheet B onto Spreadsheet A and mat...
OliverScheurich
Jun 28, 2023Gold Contributor
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Does this return the intended result?