2 Replies Latest reply: Oct 16, 2014 8:23 AM by Nayan Lalla RSS

    Linking Tables with a Condition



      I have 2 excel tables.  The one table is a "Customers Table" and the other is a "Sales Table"


      The customer table is as follows:


      Customer CodeCustomerCustomer Group
      ELS001ElSat - JOHANNESBURGBranch


      The Sales table is as follows.


      Customer CodeItem CodeQtySales Value


      If we sell Item Code " INSL" to Customer ELS001 , I want the Customer Group to change to , say , "Multichoice" , otherwise the Customer Group must stay as "Branch"


      How do I create the scripting for this?


      Thanking you in advance.


      kind regards