Forum Discussion
Solved
Contest Scoring
I created a spreadsheet to calculate points for a Skillathon test we give to kids at our fair. On the main sheet, we input the points earned for each question. I created a second sheet to calcul...
I think you want a lookup function like this:
=XLOOKUP(A3:A8, Sheet2!E3:E8, Sheet2!G3:G8)
where is assume the Team # on the main sheet are A3:A8, The Team # in the Final Placement table are Sheet2!E3:E8 and the Team Points are Sheet2!G3:G8. You might have to adjust accordingly.
Thank you, that was perfect!