You can use a UDF function. put the search strings in a range of cells in
the workbook in the order you want them searched. Call with this worksheet
function

=SearchStings(A1:A10,$C3)


Function SearchStings(SearchCriteria As Range, SearchString As String)

SearchStings = "Not valid"
For Each cell In SearchCriteria
If InStr(SearchString, cell.Value) 0 Then
SearchStings = cell.Value
Exit For
End If
Next cell


End Function


"bbal20" wrote:

I was wondering if there is a way to re-write the formula below or nest more
than 7 IF scenarios. I need to be able to check for several scenarios or more
than 7. Is this possible?

=IF(ISNUMBER(SEARCH("TIER 1",$C3,1)),"TIER 1",IF(ISNUMBER(SEARCH("TIER
2",$C3,1)),"TIER 2",IF(ISNUMBER(SEARCH("TIER 3",$C3,1)),"TIER
3",IF(ISNUMBER(SEARCH("Chicago",$C3,1)),"Chicago", IF(ISNUMBER(SEARCH("St.
Louis",$C3,1)),"St. Louis","Not Valid")))))
--
Thank you for your help and support