Excel formula sorting IP Address’s

I’m working in Excel 97.

I have in column A, the static Ip address’s. On another sheet, I’m try to compare the IPs in column A to 4 sets of 8 IP subnets to determine which IP address I want to work with.

I’m trying to do a search on the third period, but I’m not sure how to do it.

eg. Have static IP’s of
10.22.35.101
10.64.21.3
10.55.14.25

I have a set to compare against:
10.22.30
10.22.31
10.22.32
10.22.33
10.22.34
10.22.35
10.22.36
10.22.37

In this case the first IP would be valid or true

How do I figure this out?

Thank you