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

    Linking Tables with a Condition

    Nayan Lalla

      Hi

       

      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
      ELS001INSL100100,000
      ELS001ABC5025,000
      ELS001FEPT6017,000

       

      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

      Nayan