Searching for multiple terms in multiple cell columns

Hi There,

I am quite new to excel and would really appreciate some help with a homework question I have to prepare for a presentation next week. I have just imported a query from Microsoft access into EXCEL and need some help finding relationships between two different cell columns. I have attached the file. What I am trying to do is If the word "TRUE" displays in column B AND word "Visa" appears in column C, than for a letter "A" to appear in column E. I have been experimenting with the IF(ISNUMBER(SEARCH) function but can only seem to search for one word (played around with that in column D). Any help would be really appreciated, thank you!

perfect thank you i figured it out and used this equation

=IF(AND(ISNUMBER(SEARCH("TRUE",B:B)),ISNUMBER(SEARCH("Visa",C:C))),"A","")

wow that's a much easier equation thank you