Under the Keyword Column I am needing these 4 words (Spud, Log, Perf, Frac) returned if it finds them in the Report Column for the same row, if it doesn't find any of the words I just need it to be blank. I found this function =IF(ISNUMBER(SEARCH("perf",C7)),"Perfs","") that I got to work for the word Perf but when I tried to make it a nested funtion to look for the other 3 words it said it was too long. Is there anyway you can help? Hope this makes sense.
~Shelby
Bookmarks