w1 is the cell reference for the text that needs to be looked up..
you just may have to change that to a1?


the error could very well be caused by the fact that i used the
; as list separator... maybe you use a , instead ?



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Rashid Khan" wrote:

Hi there,
I copied the formula u suggested in B1.. It gives an error :-(
By the way what is the W1 in the right hand side of the formula?

Rashid

"keepITcool" wrote in message
...
Rashid,
i think you can forget the VBA..

since you're NOT requiring an exact match
THIS simple function should do..

=SUMPRODUCT(--(NOT(ISERROR(FIND($AA$1:$AA$25;W1)))))

if it's 0 = no occurance..
if higher the number of matches found :)

keepITcool