title: lookup in ssrs and return a value
body: <p>I have a table with three columns, in column 1 I have a name and column 2 I have a quantity.</p>
  
  <p>I want to look up column 1 and return the value in column 2.</p>
  
  <p>I used to the expression below and it wouldn't return what I wanted.</p>
  
  <pre><code>=Lookup(fields!NAME.Value, "Paul" ,1 , 0)
  </code></pre>
  
  <p>Could anybody tell me what expression I need to use? </p>