Determine if IP is in Subnet + Lookup

[nitrobass24]

Hi guys - I have am trying to take a list of 250k IP Addresses and determine if they are in subnets that are part of my organization. I would prefer to do this with just formulas but am open to VBA as well...i just dont understand it as well.

The first two columns I have, the third is my desired output

Subnet	IP Address	Output
10.130.164.0/24	10.132.2.25	N/A
10.132.132.0/23	10.148.1.10	10.148.1.0/24
172.16.10.0/25	192.168.10.12	N/A
192.168.23.0/24	10.130.164.52	10.130.164.0/24
10.148.1.0/24	172.16.1.1	N/A

<tbody>
</tbody>