How to use IF AND and wildcard for text ending?
 

Hello,
I'm trying to get a cell to show a message if two other cells contain some
specific text:
ex.
=IF(AND(A3="RRA05*";C3="KRF");"Tipo 4";"Tipo 1")

but I'm having trouble with the wildcard *

I have already tried ...A3="RRA05?????"... as this article code is always 10
digit long, but it also doesn't work

Should I format the cells in any specific way (as "text" or something else)
so it will work?

Thank you very much in advance, for all the help provided

Susana

How to use IF AND and wildcard for text ending?
 

Try
=IF(AND(LEFT(A3,5)="RRA05",C3="KRF"),"Tipo 4","Tipo 1")

or if the RRA05 is not always at the start


=IF(AND(ISERROR(FIND("RRA05",A3))=FALSE,C3="KRF"), "Tipo 4","Tipo 1")


"Susana" wrote:

Hello,
I'm trying to get a cell to show a message if two other cells contain some
specific text:
ex.
=IF(AND(A3="RRA05*";C3="KRF");"Tipo 4";"Tipo 1")

but I'm having trouble with the wildcard *

I have already tried ...A3="RRA05?????"... as this article code is always 10
digit long, but it also doesn't work

Should I format the cells in any specific way (as "text" or something else)
so it will work?

Thank you very much in advance, for all the help provided

Susana

How to use IF AND and wildcard for text ending?
 

=IF(IF(ISERROR(SEARCH("RRA05",A3)),0,1)+IF(ISERROR (SEARCH("KRF",C3)),0,1)=2,"Tipo 4","Tipo 1")

FYI,
'Search' will look disregard upper/lower case.
'Find' will consider case.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown


"Susana" wrote:

Hello,
I'm trying to get a cell to show a message if two other cells contain some
specific text:
ex.
=IF(AND(A3="RRA05*";C3="KRF");"Tipo 4";"Tipo 1")

but I'm having trouble with the wildcard *

I have already tried ...A3="RRA05?????"... as this article code is always 10
digit long, but it also doesn't work

Should I format the cells in any specific way (as "text" or something else)
so it will work?

Thank you very much in advance, for all the help provided

Susana