Forum Discussion
Solved
Same formula not working for each field
Hi everyone, I'm trying to populate one column based on the matching names from two sheets. I have two sheets, first one is with submitted answers (sheet1) and second one is with the names an...
Did you perhaps add a space after the name in one row but not the other?
Did you perhaps add a space after the name in one row but not the other?
I checked the names and yes there were some spaces either on sheet1 or sheet2 so they were not matching.
The form for submitting answers is created in Microsoft Forms and sometimes it's adding spaces by itself as i can see, not sure why.
I checked both pages and now it's working. Thanks for the hint.
The form for submitting answers is created in Microsoft Forms and sometimes it's adding spaces by itself as i can see, not sure why.
I checked both pages and now it's working. Thanks for the hint.