title: Match and Get the Value from another table (Vlookup)
body: <p>I have 2 tables connected to each other through col A. I want to match the column C with Col A and get the value of Col B.</p>
  
  <p>For Example,</p>
  
  <p>Table 1</p>
  
  <pre><code>ColA    ColB     Colc
  a        a1       b
  a        b1       c
  c        c1       a
  </code></pre>
  
  <p>Table2</p>
  
  <pre><code>ColA ColB
  a     a1
  b     b1
  c     c1
  </code></pre>
  
  <p>Now, I have already created relationships between Table2 and Table1 for my other calculations connecting both the tables with the colA.</p>
  
  <p>Now, I am trying to match ColC from Table1 with ColA of Table2 and return the value of ColB from Table2 as MatchedOutput.</p>
  
  <p>Expected output
  Table1</p>
  
  <pre><code> ColA    ColB     Colc     MatchedOutput
      a        a1       b     b1
      a        b1       c     c1
      c        c1       a     a1
  </code></pre>