A excel function similar to ListFind()

[Guest]

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

 

[Lonnie M.]

Hi,
I think you might look into the index match functions, see:
http://www.contextures.com/xlFunctions03.html
If I understand you, this will help you if you are looking to match a
value to a description.

HTH--Lonnie M.

 

[Tom Ogilvy]

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

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

 

[Guest]

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

 

[Guest]

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