How to get the value of the last Row based on a Condition

[MostafaBouzari]

Hi Everyone,

I'm hoping everyone is Feeling good in this Time.

i have a customer number Column that sometimes does not exist so it's null.

but the Customer Name thank Sort tool is available Like the excel File that i Have attached.

Want to get the Customer Number based on the Costomer Name

So i'm using a multirow tool and my condition is the following 

IF IsNull([Customer Nr.]) && Contains([Company name],[Row-1:Company name] ) 
THEN [Row-1:Customer Nr.] 
ELSE [Customer Nr.] 
ENDIF

But it's not giving me what i was looking for.

How can i achieve this?

Best Regards

Mostafa 

[ydmuley · Accepted solution]

Hello @MostafaBouzari 

How about you trying to update the formula to look something similar to this?

You can add additional conditions if you would like to.