'I'm trying to map a list of products to a summarised list of products
The formula I'm using is IF(ISNUMBER(SEARCH($Y$2,F2)),$Z$2,IF(ISNUMBER(SEARCH($Y$3,F2)),$Z$3,"No Match")) 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.
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|