Hello,

I am attempting to use an IF function to return the value "Government" when any of the four cells I'm looking in contain a variety of names that are considered government for my process.

I have about 10 names that could all be condsidered government listed on a separate tab.
Ex: A1-A10 would be "DFAS", "VA", "Army", "Navy", "Military" , etc.

The cells I'm looking in have long names like "Southwestern Military Hospital" or "Shorewood Partners for VA Medical Center". However, I only need to see the word "military" or "VA" show up at all in any of the four cells Im searching through.

What I have been doing is concatenating the four cells into one and using a wilcard in the criteria of my ISNUMBER SEARCH function to look in the concatenated cell. When Im dealing with parts that dont have multiple names my formula looks like this:

=IF(ISNUMBER(SEARCH("*Alliance*", F1)), "Alliance", "x") where F1 is the concatenated results of the four cells I'm looking for the word "Alliance" in.

I've tried things like =IF(ISNUMBER(SEARCH(OR("DFAS","VA","Army"),F1)),"Government","x") where I reference the cells where DFAS, VA, and Army are located (rather than writing them out as shown above) on a serparate sheet, but I'm having no luck.

Could I use an array or some type of vlookup for the multiple search criteria? I'm trying to avoid writing a string of 10 IF statements for each verison of Government names I'm looking for.

Thanks!
Justin