Hello,
I have a vlookup that will return values such as the following:
1. "123.123.123.xxx"
2. "123.32.32.89 (VPN)"
3. "123.32.32.89 RT"
4. "123.32.32.89 VPN"
5. "D 123.32.32.xxx S 123.32.123.xxx"
I currently have the following formula which only works in the first instance...