Thread: If statement checking list
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default If statement checking list
Correction...

=IF(COUNTIF(ListRange,Criteria)0,"Yes","No")

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply With QuoteReply With Quote