Forum Discussion

gmason96's avatar
gmason96
Occasional Reader
Jul 14, 2026

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 calculate the points for question 20. I have a table set up to auto-sort the teams by Amount. I want to be able to take the points from this table and have that input into the main score sheet.

 

 

 

 

 

 

 

Need help with the function for this.

 

excel
Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Silver Contributor
    Jul 15, 2026

    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.