View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt G[_9_] Matt G[_9_] is offline
external usenet poster
 
Posts: 3
Default A excel function similar to ListFind()

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@)