In Powershell I am wondering the best way to achieve the updating of a custom attribute from a column in a CSV for users, based on the matching of a different column to a different attribute.
The spreadsheet essentially has a "last name" field that we know should match. Ideally I'd want to try and see if Powershell could:
1. Import the csv of a few hundred rows
2. Look up the user account in AD based on the matching of the EmployeeID and LastName columns in the spreadsheet
3. Update the other attribute (in this case it's a custom AD attribute called "personalEmail" to the corresponding "personalEmail" column, if the other columns match accordingly...