Seems simple
however I've tried using some kind of combination of substitue /
find / mid and right functions however I can't seem to get it to
work..

please don't tell me not to use spreadsheets for ip address
management / natting (Thanks)

10.10.15.35 should match 192.168.95.35 but not match 192.158.96.135

can someone help here?

Thanks.