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


[TABLE="width: 500"]
<tbody>[TR]
[TD]Subnet[/TD]
[TD]IP Address[/TD]
[TD]Output[/TD]
[/TR]
[TR]
[TD]10.130.164.0/24[/TD]
[TD]10.132.2.25[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]10.132.132.0/23[/TD]
[TD]10.148.1.10[/TD]
[TD]10.148.1.0/24[/TD]
[/TR]
[TR]
[TD]172.16.10.0/25[/TD]
[TD]192.168.10.12[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]192.168.23.0/24[/TD]
[TD]10.130.164.52[/TD]
[TD]10.130.164.0/24[/TD]
[/TR]
[TR]
[TD]10.148.1.0/24[/TD]
[TD]172.16.1.1[/TD]
[TD]N/A[/TD]
[/TR]
</tbody>[/TABLE]