## If cell contains one of many things in Excel

This tutorial shows how to calculate If cell contains one of many things in Excel using the example below; Formula {=INDEX(results,MATCH(TRUE,ISNUMBER (SEARCH(things,A1)),0))} Explanation To test a cell for one of several things, and return a custom result for the first match found, you can use an INDEX / MATCH formula based on the SEARCH function. In the …