Comparing folder structures

A note to self!

Using the following in powershell :

Get-ChildItem -recurse -File | select Name, Directory, Length | export-csv

Against two folder structures (for instance transferring between machines) and then load both lists into Excel and in a cell adding

=IF(ISNA(VLOOKUP(D2,$A$2:$A$100000,1,0)),"no","yes")

Where D2 is a filename and the range to compare to is A2:Axyz will instantly identify if files exist in both lists or not and can then be filtered in Excel.

that just for filenames but it would be easy to combine the directory as well.