2 Replies Latest reply on Sep 22, 2017 9:44 AM by Ray Givler

    look up a value in a column and populate it in another column

    Mira Young

      Hello fellows,

      I have a table looks like below:

       

      Sales personSales $
      MM1200
      CC1500
      VV1000
      RR1030
      EE1850
      DD1080

       

       

      I need to generate another column, which is the "Sales $" of a chosen subject sales person (selected in "Sales person" column). For example, I chose "MM" as my subject sales person, then MM's Sales $ 1200 will be in every cell of the new column.

       

      Sales person
      Sales $
      Subject Sales Person's Sales $
      MM12001200
      CC15001200
      VV10001200
      RR10301200
      EE18501200
      DD10801200

       

      How would I be able to generate the column of "Subject Sales Person's Sales $", based on a chosen subject sales person in a parameter?