User Profile
Danche1
Copper Contributor
Joined 9 months ago
User Widgets
Recent Discussions
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,
