Building Vendor profiles and establishing master vendor name for match/index
We manage a lot of vendor information in Smartsheet for various projects. We are working on building a master list of outcomes for a client and the vendor name can vary project to project. As an example, one project may say, ABC Corp and another will list the same vendor as ABC Corporation. We want to analyze the outcomes for both ABC Corp and ABC Corporation on one master sheet and have written index/match formulas but this would require so many vendor name columns. Is there a better formula or way to manage these vendor name variations?
Help Article Resources
Check out the Formula Handbook template!