View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Vary response IF certain text is contained in a cell


Hi All

I need a formula which says this :

If the text 'AB' is contained anywhere in E2 , put 'Yes'. If not put
'No'.

Can someone help with this?



Best Wishes