Hello and thanks in advance for the help. Below is a formula that works as designed. However now there's a need to add to it and I just don't know how to go about doing it. As you can see I'm searching in cell I4 for any of those references and if I4 has those references then my result is "PNC Online Fees". The addition I need to account for is this. Cell I4 must also contain 10405064. If it doesn't then my results is an empty cell. How do I incorporate an AND statement along with the OR statement? So I4 must have 104064 and any of the OR statements in order for the result to be "PNC Online Fees".
I hope I'm explaining this correctly.
=IF(OR(ISNUMBER(SEARCH("PNC MERCH DISCOUNT",$I4)),ISNUMBER(SEARCH("PNC MERCH INTERCHNG",$I4)),ISNUMBER(SEARCH("PNC MERCH FEE ",$I4)),ISNUMBER(SEARCH("PNC MERCH DISCOUNT",$I4)),ISNUMBER(SEARCH("PNC MERCH INTERCHNG",$I4)),ISNUMBER(SEARCH("PNC MERCH FEE",$I4)))=TRUE,"PNC Online Fees","")
I hope I'm explaining this correctly.
=IF(OR(ISNUMBER(SEARCH("PNC MERCH DISCOUNT",$I4)),ISNUMBER(SEARCH("PNC MERCH INTERCHNG",$I4)),ISNUMBER(SEARCH("PNC MERCH FEE ",$I4)),ISNUMBER(SEARCH("PNC MERCH DISCOUNT",$I4)),ISNUMBER(SEARCH("PNC MERCH INTERCHNG",$I4)),ISNUMBER(SEARCH("PNC MERCH FEE",$I4)))=TRUE,"PNC Online Fees","")
