Is this what you mean?

=IF(VLOOKUP($A4,'look ups'!$A:$B,2,FALSE)>$B$1,VLOOKUP($A4,'look ups'!$A:$B,2,FALSE),"")