Forum Discussion
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 and team name (sheet2) that i have.
I want based on the names from sheet2, whenever someone submit the answer with their name in sheet1 to pick up the team name from sheet2 and fill a column in sheet 1.
At the moment i'm using following formula
=INDEX(Teams!A$1:B$78,MATCH([@[Full name:]],Teams!A$1:A$78,0),2)
(sheet2 is Teams in my file)
My question is why this formula it's not working the same for each field. For the same guy this formula didn't worked the first time when he submitted his name, but did worked the second time.
This is from sheet 1 with submitted answers.
This one is from sheet2 with name and team names.
Thank you,
Did you perhaps add a space after the name in one row but not the other?
3 Replies
Excel for the web may not always recalculate formulas immediately, especially in large or complex workbooks. Try manually forcing a recalculation (e.g., by pressing Ctrl + Alt + F9) to see if it resolves the inconsistency.
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.
