Hello!
I have a process that currently involves multiple sheets and requires manual copy & paste to complete. This is not a scalable solution for our business, so I’m trying to build a workaround to combine data from several sheets and automatically update data in some sheets when certain actions are triggered. Some of these sheets receive data via form submissions, some manually, and some with copy/move automations. Since copying only some columns within a row to another sheet with an action is not possible, I am trying to build formulas that can pull data from other sheets based on some criteria (vlookup).
All of the sheets have one column in common, Company Name. In one of these sheets there is also a unique company ID for each company name. My idea is that I can pull that unique Company ID into other sheets with a vlookup based on the company name. The problem I have is that the name is not always consistent on every sheet (the person that input the name on one sheet may have altered it slightly, added a suffix, etc). To get around this I planned to use TRUE in my formula to get an approximate match. This is not ideal but could be a possible solution. When I do this, I get some matches on approximate, but #NOMATCH when the value is exact. Is there a way to get around this?
Maybe I am going about this the wrong way and there is a better solution for automating this process while maintaining accurate consistent data in Smartsheet. Here is a screenshot of the columns, the highlighted rows are the exact matches returning a #NOMATCH
Any ideas are appreciated!
