1 Reply Latest reply on Nov 14, 2017 8:15 AM by Joe Oppelt

    How can you populate blank/null values in a Table using a Lookup Calculation?

    ashwath.sekaran

      In the attached worksheet, I have a table representing how many people from various groups are assigned to various trains.  I have parameters that allow the user can see how the table changes if they move all people from a certain group to a certain train (which they choose).  This is done using the LOOKUP() function to add all other values in the table row.

       

      Table with No Parameters ("None") Selected

      GroupTrain 1Train 2Train 3Train 4
      G15311
      G2442
      G355


      Table when Parameters to Move G1 to Train 2 Selected

      GroupTrain 1Train 2Train 3Train 4
      G101000
      G2442
      G355

       

      The issue I am having is if the user is trying to populate a blank cell using the parameters, like if they choose to move G2 to Train 1.  The value does not show in the cell, it still stays blank.  I guess this happens as there's no row in the data (each row represents one person) where a person is a part of group 2 and is assigned to train 1 but there has to be a way to work around this.  I have attached the workbook as well as the data.