On 2002-11-06 11:37, G wrote:
=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
This message was edited by Mark W. on 2002-11-06 12:14If match_type is 0 and lookup_value is text, lookup_value can contain the wildcard characters, asterisk (*) and question mark (?). An asterisk matches any sequence of characters; a question mark matches any single character.
On 2002-11-06 11:47, G wrote:
Mark,
Thank you! Will both of these do the same, is mine correct?
Thanks,
gs
On 2002-11-06 12:17, G wrote:
Mark,
I have looked at that and that is how I was able to get my results, someone else had asked for an example therefore I reply with an example. Can you explain why both your formula & mine formula come out with the same results?
Previous Reply:
I think I answered my own question, but I am not sure how or why it is working.
Here is what I came up with and it appears to work.
=IF(ISNUMBER(MATCH("?*?"&"*P*",E2,0)),"0","1")
Thanks,
gs
Thanks,
g
This message was edited by G on 2002-11-06 12:20