SOLVED

Sorting Grades for extra credit

Copper Contributor

Hi so I am trying to come up with a quick formula to have the number of extra credit points combine with the list of students in the class. Not everyone will have extra credit, so some will come up as not being in the second list. Essentially I have one list of everyone in the class. Then I have another list of the students who did extra credit and their points. Is there a way to put the extra credit in the list of students in the class without manually typing in each number? IE is there a formula?

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Kat97915 

=IFERROR(VLOOKUP($A2,$F$2:$H$16,COLUMN(B1),FALSE),"")

 

Maybe with this formula as in the attached file.

I think that is in German...
I figured it out!! You are a lifesaver!!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Kat97915 

=IFERROR(VLOOKUP($A2,$F$2:$H$16,COLUMN(B1),FALSE),"")

 

Maybe with this formula as in the attached file.

View solution in original post