Feb 01 2022 01:41 PM
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?
Feb 01 2022 02:08 PM
Solution=IFERROR(VLOOKUP($A2,$F$2:$H$16,COLUMN(B1),FALSE),"")
Maybe with this formula as in the attached file.
Feb 01 2022 02:08 PM
Solution=IFERROR(VLOOKUP($A2,$F$2:$H$16,COLUMN(B1),FALSE),"")
Maybe with this formula as in the attached file.