Try
=IF(COUNTIF(B1,"*sec.gov*"),"Official ","")&IF(A1="","Launch","Close")
Try
=IF(COUNTIF(B1,"*sec.gov*"),"Official ","")&IF(A1="","Launch","Close")
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks