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

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

=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