yogi_From A:B Pull In D:E Data Only For Names Specified In Column C

Google Spreadsheet   Post  #2519

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-28-2018

question by: Ian Banker
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/OI0qBi7G5NA;context-place=mydiscussions

Two columns. Copy every single match (inc. doubles) from two columns to a third column?

https://docs.google.com/spreadsheets/d/1us9ZB_IDGdK1GjNaf1tnEHosVEk7zeUvYA0aPPXliMs/edit?usp=sharing

This is simply a trial version. In reality, I am attempting to keep track of student records of attendance by class.  In my real document, I have 2500+ students, with 400+ possible classes, just to give you an idea of scale.  The fake document I have above gives a decent idea.

I have a list of students in column A and the point they earned for something in column B.   I need to take the students that are listed in Column D and pull every single match from column A, meaning if John is listed 3 times, I need all 3 of his "points earned" and not just the first value, and put all of those names and the corresponding values into F and G.  They do not need to be sorted, as the initial 2500+ name list I run is already sorted when I begin.

Any help is super appreciated.