Re: $$Excel-Macros$$ Re: Match text to a list

2012-03-28 Thread Brian Black
Kris, Sorry, you are quite right. I made the mistake of copying the previous code and replacing the prvious code with the previous codes. thank you so much for your patience. On Thu, Mar 22, 2012 at 2:49 PM, Kris wrote: > That's not true. > > MATCH("A",**L6:L27,0) is not equal to MATCH("AA",

Re: $$Excel-Macros$$ Re: Match text to a list

2012-03-22 Thread Brian Black
This works just as well as the other code but still has the problem, If range (L6:L27) has the letters AA in it then it shows A as a match and says report A is already done On Wed, Mar 21, 2012 at 4:34 PM, Kris wrote: > Hi > > Replace > > Flg = Evaluate("ISNUMBER(LOOKUP(9.**999E+307,SEARCH(D18,

Re: $$Excel-Macros$$ Re: Match text to a list

2012-03-21 Thread Brian Black
The code you supply works perfectly except for one issue. I am checking a column to see if I have run a report before and therefore the check for the match. The problem is I have one report marked AA and another marked A. If I have run the report AA before then when I run the report A, the code