Misattributed Quote Embarrassment: How Do You Double-Check?

I’m a freelance writer who recently published an article on urban policy, and I made a blunder that’s been gnawing at me. In the third paragraph, I quoted a city planner named Michael Carter—only to later realize the source was actually his colleague, Mark Carter. Both have similar titles at the same firm, and the misattribution slipped through editing. The article was already live when a reader pointed it out. I’m mortified, but I’m trying to channel this into better habits. I corrected the text and issued a brief erratum, but I’m left wondering: how do more experienced journalists avoid these kinds of mix-ups? Do you cross-verify names and roles in your own workflow with extra diligence, especially when handling multiple sources with similar profiles? I pride myself on thoroughness, yet this feels like a gap in my process. Any advice on systems to prevent this, short of working in complete silence with color-coded spreadsheets? I’d appreciate your insights, not just to fix this but to ensure it never happens again.