Forum Discussion
andrews1685
Aug 10, 2022Copper Contributor
FILTER and "linking" cells
I have 2 spreadsheets, 'Inventory' and 'Users'. Inventory includes make, model and S/N. I utilize =FILTER to import the make, model and S/N into the User spreadsheet and assign a user to the device. ...
NikolinoDE
Aug 11, 2022Platinum Contributor
If I may suggest, PQ would try to merge both tables.
Learn to combine multiple data sources (Power Query)
Import data from a folder with multiple files (Power Query)