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