ace that's even better that what I was after, cheers! M@)

"Tom Ogilvy" wrote:

Assume the list is in K1:K1000 on a sheet named Sheetlist.

=if(iserror(Match(A1,SheetList!$K$1:$K$1000,0)),"N o Match", "Match")

--
Regards,
Tom Ogilvy


"Matt G" wrote in message
...
Hi. I am trying to write a function that compares the value of a cell to a
pre-defined list, and renturns a result of any description.

For example. I have a colum of 1000 random words. I want to show next to
the
column whether one of these words match.

I have tried: Find and Search.

I nearly was able to do it, but my list was too long for the formula.

Can I reference the list of values to mach, and get the formular to look
there.

Please say this is possible...

M@)