This works great but i have few exception where this is breaking, some place when it is trying to compare an ip such as 192.5.1.26 and the Col B in Sheet 1 has 192.5.1.255 it is not able to calculate, Did you have a fix for that.
Thanks for the great tip.