IF formula resulting in FALSE for some users, but not others

[jacarroll09]

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"))

 

[jacarroll09]

Hi jkatw,

Your formula in Post #8 worked for the user that was having trouble last week. Thanks so much for your help here! I was wondering if you could please explain how the formula works so that I can apply this if necessary in the future?

Thanks again!

 

[jtakw]

Well, my formula in Post # 8 is does the same thing as your original formula, I suggested my formula because I suspect some of your users Excel might require your formula to be Array-entered in order to work, my formula is Normally entered, so there's no chance of that particular problem.

My formula searches E2 within your A and B Column lists, the LOOKUP function is able to handle "arrays" and output the result accordingly.
I recently explained some of the aspects of how the LOOKUP function works in another post, you can read it here:

If value (A2) is in Column J or J, then return Column L

Hi Community, I am trying to find if a value is found in one or two columns to return a value from another column. I have tried, Vlookup with IF / Or, Match with IF/OR, Index / Match, and plain IF/OR. I have not had any luck. I am hoping you can help. A snapshot is attached - very simple...

www.mrexcel.com

Hope this helps.

 

[jacarroll09]

Thanks again for your help. I'll go ahead and mark this solved!

 

[jtakw]

You're welcome, thanks for the feedback and glad to know it's working for you.