2019 Points

IN the attached, I need for each sheet 1D, 2D, 3D, 4D, Hit to refer back the member sheet. Validate 3 ways first if name is not on sheet then validate is NO and points to count is 0 2nd if name is on sheet but not current or have 19 as year (which eve is easiest) then validate is No and points to count is 0 3rd if name is on sheet and current (or 19) then compare the points start date on membership list to the show date on 1D.. if on or after then "yes" and points to count is same as points.. If show date is prior to points to start date then no and points to count is 0 ** and is a pivot table the best way to keep the sum of points for each person. I'm very basic at excel and don't know many shortcuts