I'm glad that worked for you.....thanks for letting me know.


***********
Regards,
Ron

XL2002, WinXP


"joker_r_me" wrote:

awesome.. thanks.. just made my job a lot easier than trying to run this in
SQL using a bunch of tables to run statements of comparison.

"Ron Coderre" wrote:

(This may be a double-post....my PC did something "funny" the first time I
tried to post)

With
A2:A77 containing file extentions (eg TXT, BAT, XLS, etc)

B2: (a file extention)

This formula tests if any of those cells matches the value in cell B2
=IF(COUNTIF(A2:A77,B2),"Pass","FAIL")

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"joker_r_me" wrote:

I need to create an (if) formula that isn't (if cell a = cell b then pass,
fail)... I need to make it more like (if Colum A = cell b then pass, fail)...
is that possible and how do I create it?