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
Solved! Go to 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.