jacarroll09
New Member
- Joined
- Mar 4, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I'm using the following formula that refers to a sheet named "NetworkList" within the same workbook to tell the user whether a geographic location in column E is in or out of a specific network. The NetworkList sheet lists the in and out of network locations in column A and B. When some users run the formula, it works properly. When others run the formula, every cell says FALSE. All users in question are using Office 365. Does anybody know what could be going wrong here, and what can I do to get this running correctly for all users?
The formula is below:
=IF(SUM(N(ISNUMBER(SEARCH(NetworkList!$A$1:$A$299,E2))))>0,"in-network",IF(SUM(N(ISNUMBER(SEARCH(NetworkList!$B$1:$B$55,E2))))>0,"out-of-network"))
The formula is below:
=IF(SUM(N(ISNUMBER(SEARCH(NetworkList!$A$1:$A$299,E2))))>0,"in-network",IF(SUM(N(ISNUMBER(SEARCH(NetworkList!$B$1:$B$55,E2))))>0,"out-of-network"))