Conditionally Update existing

[JBATAIDE]

Hello,

I was trying to update a column if blank/null by referencing other rows which fit certain criteria. I think this could be accomplished through Multi-row formula tool

In the example in attachment the logic would be:

If LT column is blank then populate it with the LT value from row with:

-Same 'Indication', Same 'Brand' and 'Country'

-Else Same 'Brand' and Country'

In my real data there may be multiple rows that satisfy those conditions. the row to pick the data from can be arbitrary.

Thank you in advance.

Let me know if not clear enough.

Kind Regards,

Joao

[Jonathan-Sherman · Accepted solution]

Hi @JBATAIDE,

I haven't gone down the route of a multi-row formula, instead using summarise and joins for each of your two scenarios:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan