Thread: Which function to check any value existed withing a list?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Cutter
 
Posts: n/a
Default Which function to check any value existed withing a list?

With your values in A1:A10 and your value to search for (4) in B1 try
this:

=COUNTIF(A1:A10,B1)0

This will return TRUE if there is a 4 (or any other value you put in
B1) in the list and FALSE if that value is not in the list.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=497082

Reply With QuoteReply With Quote