Help with match formula

[G]

=IF(ISNUMBER(MATCH("***"&"*P*",E2,0)),"0","1")

How do I fix this formula to look for both * & P in no particuliar order?

Once again Thank you in advance for your help......
G

 

[G]

Aladin,

You are so right, you do have a name and I am sorry. I did test your suggestion, and found ?*? does not get everything. However, I have attached my sheet to show reasons for "0" & "1", choice of "Font"....

Combined Kmart & Coolidge Code & Rate.xls
	D	E	F	G	H	I
1	Store#	*Code	TaxRate	Open/Closed	Check*Codes	Associate
2	1889/9681	CO01	30.7	1	Fix	KMC
3	1889/9681	CO02	30.7	1	Fix	KMC
4	1898/3161	MA18	8.0283	1	Fix	GCS
5	1900/3293	*ALP	2.778	0	OK	JAL
6	1900/3293	PO01	111.37	1	Fix	JAL
7	1903/3633	FA01	33.41	1	Fix	GCS
8	1905/3899	*COU	1.374	1	Fix	JAL
Data

 

[Mark W.]

On 2002-11-06 12:17, G wrote:
Mark,

...Can you explain why both your formula & mine formula come out with the same results?...

=IF(ISNUMBER(MATCH("?*?"&"*P*",E2,0)),"0","1")

"?*?"&"*P*" doesn't check for or require the presence of an asterisk ("*"). A tilde must be used to idenfify "*" (e.g., "~*").

Also, "?*?"&"*P*", is the same "?*?*P*". And, in turn is the same as "??*P* which requires a P to be preceded (at a minumum) by any 2 characters. Is that what you intend? Provide some examples of text strings that you expect to pass and fail a desired wildcard pattern.

 

[Mark W.]

G, I just saw your posting above...

"~**"&"*P*" is the same as "~**P*" which requires a leading asterisk (*) and a P anywhere in the text string following the asterisk.

 

[G]

Mark,

I used your formula, because as Aladin pointed out, my formula does not catch all. You formula is exactly what I want, I just did not know it until ALADIN pointed it out to me.

Thank you for all of your help so that I could understand what I was looking at.

Sincerely,
G