Autofilling the rows based on the condtion

[praneshsapmm]

Hi there ,

I have this requirement of autofilling the values based on condition . 

Scenario is : 

I have two columns Column1 and Column2 . 

Column1 can contain Sale A , Sale B  or Sale C . 

If any one cell in Column 1 contain Sale A , then all cells under Column2 must be autofilled to 'Not in Jurisdiction' .  If there is no cell with value 'Sale A' then all cells under Column2 must be autofilled to 'In Jurisdiction' . 

Hope this is clear . 

Thanks .

[Emil_Kos]

Hi @praneshsapmm,

I just created a simple test and afterwards, I have replicated the values of it for the first row using the multi-row formula:

The output:

[L_T]