Cool example, but it doesn't do exactly what I want.

I have 2 columns in my excel SS:

Area + Well Pad Number

Well Pad Number is read only.

UltraDataSource _AreaWellPadUDS= new UltraDataSource();

_AreaWellPadUDS.Band.Columns.Add("Area");

_AreaWellPadUDS.Band.Columns.Add("Well Pad");

_AreaWellPadUDS.Band.Columns.Add("Description");

{

  object[] values = { "64", "1", "My Description" };

  _AreaWellPadUDS.Band.DataSource.Add(values);

}

{

  object[] values = { "64", "2", "My Description2" };

  _AreaWellPadUDS.Band.DataSource.Add(values);

}

{

  object[] values = { "65", "1", "My Description3" };

  _AreaWellPadUDS.Band.DataSource.Add(values);

}

UltraDropDown udd = new UltraDropDown();

udd.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortMulit;

udd.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.True;

udd.DisplayMember = "Area";

udd.ValueMember = "Area";

MyGrid.DisplayLayout.Bands[0].Columns["Area"].ValueList = udd;

After Cell Update -> set the MyGrid fill in Well Pad based on the selection from Area udd...

So ideally, would like a multi-column picklist if possible that selects two separate columns (Area + Well Pad).  I would then like to create a formula that takes Area + Column + Well Pad and puts into a new column.  Thus, the exported excel allows users to enter valid data and generate a new combined (concatenated) field based on the values from the picklist. 

I expect the formulat might have to be added manually - aka $A2 & $A5 & $A3 for instance.

If not possible, would like to have an area picklist and a validation / picklist on the well pad based on the selection of the area.

For instance if Area = "64", then Well Pad = "1" or "2"
if Area = "65", then Well Pad = "2".

Anyway of achieving this???