jeudi 19 septembre 2019

Searching for multiple words and using IF/OR/Vlookup function

I'm trying to create a formula that will search a cell for the following words.. "Other" & "Repair" if either of these words are found I want it to be categorized as the word that is found. If none of these words are found I want the formula to Vlookup another column to then categorize it.

I got the formula to work for one search word, I cant figure out how to do it with two search words.

below is the formula I used for one word search criteria. =IF(ISNUMBER(SEARCH("REPAIR",B9089)),"REPAIR",VLOOKUP(E9089,Key!$D:$E,2,0))

This is what I tried doing for the two search words but it breaks at the end for the true / flase statement

=IF(OR(ISNUMBER(SEARCH("REPAIR",B9090)),ISNUMBER(SEARCH("OTHER",B9090))),"REPAIR""OTHER",VLOOKUP(E9090,Key!$D:$E,2,0))

Aucun commentaire:

Enregistrer un commentaire