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

A excel function similar to ListFind()
 

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.

A excel function similar to ListFind()
 

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

A excel function similar to ListFind()
 

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

"Lonnie M." wrote:

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.

A excel function similar to ListFind()
 

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