title: Need to conduct and INDEX and MATCH function in r
body: <p>I am at a bit of a loss on how to both approach this problem and ask the question. I basically want to conduct an <code>INDEX</code> and <code>MATCH</code> function in R and then multiply two numbers.</p>
  
  <p>Here is an example. I have two tables with different dimensions. Note the differences in both row and columns.</p>
  
  <pre><code>MASS = data.frame(taxa = c("a","b","c"), s1 = c(1,1,1), s2 = c(2,2,2), s3 = c(3,3,3))
  
  DATA = data.frame(taxa = c("b","c"), s1 = c(1,0), s3 = c(4,6))
  </code></pre>
  
  <p>I need to multiple the cells from the DATA table with the corresponding cells in the MASS table (e.g., <code>DATA cell "b:s3" * MASS cell "b:s3"</code>) and output the results to a new table. Below is the desired result.</p>
  
  <pre><code>RESULT = data.frame(taxa = c("b","c"), s1 = c(1,0), s3 = c(12,18))
  </code></pre>
  
  <p>Thanks in advance.</p>