The "one empty bundle, and the next module still runs" behaviour catches so many people, nice to see it spelled out with the rowNumber error. For the trailing-space and case issues, I've had good luck fixing it at the source: a helper column in the sheet with =LOWER(TRIM(A2)) and searching that column with a lower()/trim() on the Make side too. Do you have a preferred way to handle multiple matches when you only expect one, e.g. routing on Total number of bundles > 1 as a duplicate alert?
Yunus Emre Vurgun
Writing about AI agents, hardware, and practical software.
The "one empty bundle, and the next module still runs" behaviour catches so many people, nice to see it spelled out with the rowNumber error. For the trailing-space and case issues, I've had good luck fixing it at the source: a helper column in the sheet with =LOWER(TRIM(A2)) and searching that column with a lower()/trim() on the Make side too. Do you have a preferred way to handle multiple matches when you only expect one, e.g. routing on Total number of bundles > 1 as a duplicate alert?