title: ssrs,reporting services Look up function only picking the first value
body: <p>I have two sets with two different values with unique column identifier.</p>
  
  <p>When i use lookup The result expression is only picking the first value even though the matching is in the third row.</p>
  
  <p>DataSet 1:
  i have result set like
  Column1  column2 column3
  1 2-1 x
  2 2-2 xxx
  3 2-3 xxxx</p>
  
  <p>DataSet 2:
  i have result set like
  Column1  column2 column3
  1 2-1 4
  2 2-2 5,6,7
  3 2-3 8,9,10</p>
  
  <p>My lookUp expression is
  =Lookup(Fields!column2.Value = "2-3", Fields!column2.Value = "2-3" , Fields!List_Output.Value, "DataSet02")</p>
  
  <p>Result supposed to get 8,9,10 but the result is showing 4 which is first value.</p>
  
  <p>Not sure of the exact reason though i think i have used look up before and it worked for other reports but not for this..</p>
  
  <p>Does groupings has anything to do with the reports if so my tablix doesn't have any groupings at all.</p>
  
  <p>Tried may blogs but couldn't find any answer.</p>
  
  <p>Any help would be much appreciated.</p>
  
  <p>Thanks,
  VR</p>