Is there a way of factoring in or adding a vlookup formula to the following formula
=SUMPRODUCT( (RIGHT($A$1:$A$6, 1)="7") * $B$1:$B$6)