title: Reference an Index for current status
body: <p>I am trying to figure out how to have Excel take a column of text from one table and reference another table as an index of what value to enter back into the first table. Example:  </p>
  
  <p><strong>Table 1:</strong>  </p>
  
  <pre><code>Greg__Blue__5  
  Cindy_Green_3  
  </code></pre>
  
  <p><strong>Table 2:</strong></p>
  
  <pre><code>Green__ 3
  Blue____5
  </code></pre>
  
  <p>I want to populate the third column with the number that lives in Table 2. So that I will have table two act more like an index as data changed in Table 1.</p>