Rename all files in a folder with PowerShell

dir | rename-item -NewName {$_.name -replace ".xlsx", "-copy.xlsx"}

Excel : vlookup to ..lookup

How to lookup if a value in a given cell is present in a set of values?

Using VLOOKUP

=VLOOKUP(A1;H:H;1;FALSE)