I am trying to clean up a database of equipment assets that we have in inventory. I need to search multiple fields for a supplier name and populate a new column "Supplier" (the database has many more columns and rows than shown here). The supplier name can show up in multiple fields and is often misspelled or the supplier name has changed since it was entered. I created an Excel file with all of the suppliers and common ways that they can be misspelled or changed from. I have tried doing multiple Find & Replace steps, one for each column I want to search, and then merging the findings back into a single column, but that gets messy rather quickly. I also tried Transposing the data into a single column, but that is rather cumbersome to merge back into the list with a single supplier column as well.
Is there a way to search an entire row of data and populate a single output column?
