4 Replies Latest reply: Oct 22, 2013 1:28 AM by Rajashmita Kar RSS

    lookup

    Rajashmita Kar

      Hi Guys,

       

      I have two column A  and B

       

      A    B  C

      1    a   N/A
      2    1    1

      3    c    N/A

      4    2    2

      5    d     N/A

       

      Now i need to calculate a field C where it will check row wise like B column first row value is a, it will search a  in full A column and if it finds the same value it should return a or else n/a.

       

      PLEASE HELP ME ON THIS