We need a power shell script the will compare the Address field in AD with an address in a list, table, or file. Only If it matches any address in list or file it will place the corresponding Site Number - City into the Office Field in AD. If the script cannot find a matching address or the AD address field is blank it should skip to the next user in AD.
So the office will have "543 - Howard", "234 - Walker" or "972 - Clearwater" (Except without Quotes).
Example: List or table would have:
Company Address City SiteNumber
12345 Bolen RD Plinkdon 258
67890 Tree Circle Howard 543
55555 Parrot Dr. Clearwater 972
23423 Box Blvd Walker 234
98093 Hwy 6 Bennington 451
Thanks very much for the help in Advance. I hope it was detailed enough.