Searching Multiple Values in Cell and Displaying Output

[Arcxist]

Good morning,

I'm trying to get this function to work, however I'm running into some issues. I'm trying to search multiple model numbers in an array using the SEARCH function, and display output using the IF function. When doing this I can only get SEARCH to find the first value in the array. I've tried using the below to no avail.

=IF(ISBLANK(E43),"",IF(ISNUMBER(SEARCH({"EX","MX","QFX"},E43)),"Juniper",IF(ISNUMBER(SEARCH("7",E43)),"Nokia",IF(ISNUMBER(SEARCH({"26","29","2960","3560"},E43)),"Cisco",IF(ISNUMBER(SEARCH("ES-",E43)),"Ubiquiti")))))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(ISBLANK(E43),"",IF(SUM(--ISNUMBER(SEARCH({"EX","MX","QFX"},E43)))>0,"Juniper",IF(ISNUMBER(SEARCH("7",E43)),"Nokia",IF(SUM(--ISNUMBER(SEARCH({"26","29","2960","3560"},E43)))>0,"Cisco",IF(ISNUMBER(SEARCH("ES-",E43)),"Ubiquiti")))))

 

[Arcxist]

Works beautifully! Thanks for the help!

 

[Fluff]

You're welcome & thanks for the feedback