title: How to match terms from multiple columns to one column using VBA
body: <p>I have Sheet1 of User ID's associated with multiple terms. The terms are listed in separate columns. There are up to 30 terms for each user. The sheet is organized as User ID in column A and Terms in Columns B,C,D, etc.</p>
  
  <p>I then have a series of Terms associated with a unique Categories in Sheet2 (Term in column A, Category in Column B). The goal is to match up users with categories. So, I need to perform a Vlookup of epic proportions or run a VBA program that compares the terms in columns B,C,D, etc in Sheet1 to the Terms in Column A in Sheet2.</p>
  
  <p>If found in Sheet2 it would be great if the formula replaced the term with the associated category in Sheet1. </p>