title: Excel get row that contains value
body: <p>I have a table with multiple columns, the first column contains index values (0,1,2...N), think cluster ID's, and the remaining columns contain text strings, call these labels. The number of columns varies per row, but always contains at least one cell with a label, singular clusters. I have another table that contains a tag for each label, ie two columns with the first as the label and the second as the tag. I would like to have a table with index values and tags. Basically I need a formula that returns the row reference if a label is found in that row. I initially though some INDEX-MATCH combination or VLOOKUP would work, but all the examples I found have only one column in their search criteria, which is known before hand. If anyone can help it would be much appreciated.</p>
  
  <p>I have tried replacing the labels with their tags, but one label can have multiple tags, so that did not work. Thnx in advance. </p>
  
  <p>EDIT:</p>
  
  <p>@Ben1344 almost has the right example, below is a small example ( I apologise for my naming convention)</p>
  
  <pre><code>Table 1 
  
  0   A   C   D
  1   E   G
  2   Z   F   X
  3   Y   
  
  
  Table 2 
  
  A   foo 
  C   foo 
  D   bar 
  E   pikachu 
  F   psyduck 
  G   jigglypuff  
  X   goldeen 
  Y   psyduck 
  z   foo 
  
  
  Desired Table 
  
  0   foo 
  0   foo 
  0   bar 
  1   pikachu 
  2   psyduck 
  1   jigglypuff  
  2   goldeen 
  3   psyduck 
  2   foo
  </code></pre>