title: How to create a flag in excel without using multiple OR statements?
body: <p>In excel how to flag a cell if the value in that matches a long list of items. I know If function with OR can be used but is there another way to get the job done.</p>
  
  <p>What i mean is,</p>
  
  <p>If i have column A which ranges from A...Z. I want to create a new column B called Flag which will be 1 if the value in the Column A is either A or C or E or F or G or H. </p>
  
  <p>Like i said i can always use if(Or(A=...),1,0) but if the list of choice is in 10's or 100's i cannot call for all 100's in the OR statement. So is there an alternative?</p>