Avatar of ferrarista

asked on 

Excel - function to find subnet match

Hi guys.

I have a worksheet with a list of subnets in a CIDR format, example
On another worksheet I have a list of servers, along with their respective IP address, say

What kind of formula would allow me to compare the value of each server's IP address and match it with the relevant subnet ?

Thanks for any help.
NetworkingMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon