Fix Excel Text Formula

I have a single formula in my Excel sheet that is meant to process text values, yet the result it produces is plainly wrong. There is no error message—the numbers simply don’t match what they should be—so I’m clearly referencing the wrong cells, using the wrong function, or missing some subtle syntax. I’m not certain which functions are best suited here; it could be a VLOOKUP, TEXTJOIN, IF combination, or something entirely different.

What I need from you is straightforward: open the workbook, pinpoint why the current formula misbehaves with my text data, then rewrite or restructure it so every row returns the correct output. A brief note explaining the changes will help me keep this clear for future edits.

Deliverable:
• Updated, working formula in the sheet, fully tested against my current dataset, plus a short explanation of the fix.

If you’ve untangled similar Excel logic before, this should be a quick task.