title: I'm trying to map a list of products to a summarised list of products
body: <p>The formula I'm using is IF(ISNUMBER(SEARCH($Y$2,F2)),$Z$2,IF(ISNUMBER(SEARCH($Y$3,F2)),$Z$3,&quot;No Match&quot;))
  The products are identified in column Y (from a longer list including duplicates in column F) and the name that I want to add to my new 'mapping' column is in column Z.</p>
  <p>My formula works, but you can only add the ISNUMBER formula 64 times and I have 75 summarised products.  Is there a better formula that allows me to do this across a range of data rather than having to create this very long formula that doesn't even capture all the products!
  Thanks for your help.</p>