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
|