Good afternoon all, I'm new to this forum and hoping some one can help.
I am having a specific problem and am very much hoping that you can help. I have added the simplified problem below; I am trying to get a cell on a sheet to return the name of the participant who won a given race (or came 2nd, 3rd, 4th etc) when the results are on one page, the participant name on a second and the formula on a third. I have included the formula that I have used with google forms (which uses formulas in a similar way to excel), however, the result always comes back as N/A if the first criteria is not met.
I hope that makes sense and hope you can offer a solution.
Sheet called Results
A B C
1 Team A Team B
2 Position 1 2
Sheet called Participants
A B C
1 Team A Team B
2 Participant Matt Laura
Sheet called Winners
A
1 1st Place
2 =if(‘Results’!B2=1,’Participants!B2,if((‘Results’!C2=1,’Participants!C2))
I very much hope some one can either see where i am going wrong or offer another suggestion.
Thanks
TJ
Bookmarks