Thread: A formula to look for a value in a blok (eg E1:J10) data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
  
Posts: 1,081
Default A formula to look for a value in a blok (eg E1:J10) data
=COUNTIF(C1:J11,A5)0

"Dolflaas" wrote:

I am looking for a formula in Excel 2003 /2007 that wil search through a blok
of data (say C1: J10) for a value (could by alfa-nomeric) entered into a cel
(say A5) Thus look in C1 : J10 for the value entered in A5 and return true if
found or false if not. Alternatively perform "X" if true else "Y"
Thank You
Reply With QuoteReply With Quote