8 Replies Latest reply: Oct 26, 2015 11:38 AM by Sunny Talwar RSS

    Compare two tables excel

    Kenny Hua

      Hello,

       

      I need to compare two tables from different excel. When I get two equal reference I need to write "True" and otherwise "false"

       

      excel 1:

      Reference1CountryInformation
      123456USAAAAAA
      234567UKBBBBB
      345678CACCCCC

       

      excel 2:

      Reference2CountryCode
      456789FRAEEEEE
      123456USADDDDD

       

      I think I need to creat a new table:

       

      TABLE:

      COUNTRYReferenceInformationCodeFlag
      USA123456AAAAADDDDDTRUE
      UK234567BBBBBFALSE
      CA345678CCCCCFALSE
      FRA456789EEEEEFALSE

       

       

      Until now, I tried to make an "If" : if(Refence1 <> Reference2, 'true', 'false') as Flag

       

      But I have an issue with this condition, when the charging never stop.

       

      Regards