Matching text between arrays to find a related number

Hi guys,

I'm trying to match Utility IDs w/ corresponding names on one sheet to the same Utility Names on another sheet and carry the UID over. The problem is that the names, while they are the same in a sense, are displayed differently at times (ex: AEP Texas Central Co. = AEP Texas Central Company)

See attached file for reference.

What I want to do is have the Utility ID's that are on the UIDs sheet "find their match" on the IOU sheet. The utilities found on IOU sheet may or may not be on the UIDs sheet. My end goal is to get the corresponding UIDs to the IOU page.


Link to excel file: https://www.dropbox.com/s/3loomq5lb988lx6/IOU1.xlsx?dl=0