Thread: Is it possible to match a cell's contents from a list ?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
Posts: 1,045
Default Is it possible to match a cell's contents from a list ?
On Tue, 12 Apr 2011 13:49:03 -0700 (PDT), kittronald wrote:

Ron and Pete,

Thanks guys, that does the trick.

Is there a way to do that without using an array entered formula ?



- Ronald K.

You could use:

=SUMPRODUCT(--ISNUMBER(SEARCH(WordList,A1)))0

But why? What's wrong with array-entered formulas?
Reply With QuoteReply With Quote