nflsales.. .solution WORKS.

Could you also please explain what these criteria for Looupfunction mean? so that I can use it again.

2;
1/((Basis!$U:$U<>"")*(Basis!I:I="Committed"))