I have a list of names I need to match up to addresses. The data was retrieved from a software and I am taking that data streamlining, renaming subaccounts to upload to another accounting software. The formula doesn't work, however the very same excel formula WILL work if I open a new workbook. I tried copying the data and still WILL not work...I'm at the ends of my ropes hoping for some help. By the way, I tried online paying for help today only to get hacked with my credit card for 3K. My bank was the one who notified me, so I am desperate needing answers since i was taken on a joy ride that I had no clue of..
