View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gail gail is offline
external usenet poster
 
Posts: 47
Default Returning a value based on a query

Hi.

What function would I use to look for specific text in a cell, i.e. Rescind
or Cancel, and return the value R or C in a designated cell?