Identifying specific text format with IF statements

[advaddi]

Hi,

So for my job, i'm screening a list that has a ton of URLs. And accepting rejecting them on the basis of keywords in the url. For example: =IF(ISNUMBER(SEARCH(".edu",A2)),"Reject"," ")
Another category of words I need to reject are city/town websites like www.picayune.ms.us where the format is generally www.cityname.XY.us where XY are the state initials.

Is there a way to identify the .xy.us format with an auto reject condition?

 

[LloydFinancials]

=IF(MID(A1,FIND(".us",A1)-3,1)=".","Reject","")

 

[advaddi]

oh thats a smart way to consider that but it results in a #Value ! error because it says a value used in the formula is of the wrong data type.

 

[advaddi]

You cant use a cell reference in the FIND function. It has to be a string

 

[advaddi]

Thanks a lot for your help. While your answer did generate a value error, it was instrumental in helping me getting to the solution by factoring in an IFERROR