New Column based on a Condition with output reference from Another Column

[DVikas]

HI All ,

I have below Table having Suppliers in 3 different Columns & Type in the last as shown below :

Supplier 1	Supplier 2	Supplier 3	Final Type
XXXX	YYYY	XXXX	GRIP 4
AAAA	BBB	YYYY	M12 Pins
BBBB	CCCC	ZZZZ	1/4 Pin

I need to Add the Final Supplier Column based on the Final Type . If , Type Contains "GRIP" , reflect the Supplier from Supplier 1 Field , if Type Contains "M12" reflect the Supplier from Supplier 2 & if it Contains "1/4" then Supplier 3.

Desired Output below :

Supplier 1	Supplier 2	Supplier 3	Final Type	Final Supplier
XXXX	YYYY	XXXX	GRIP 4	XXXX
AAAA	BBB	YYYY	M12 Pins	BBB
BBBB	CCCC	ZZZZ	1/4 Pin	ZZZZ

I tried using the Formula tool , however it doesn't refer the value from a Column . May be I am using an incorrect Tool.

[grazitti_sapna · Accepted solution]

Hi @DVikas , is this what you are trying to achieve?

Formula - if Contains([Final Type],"GRIP") then [Supplier 1] elseif Contains([Final Type],"M12") then [Supplier 2]
elseif Contains([Final Type],"1/4") then [Supplier 3] else null() endif

[DVikas]

Thanks @grazitti_Sapna 

I tried doing the same thing , however didn't work. But I don't know how , it works now. Thanks for the help.

[grazitti_sapna]

@DVikas , you are welcome, there might be a minor error in the logic written, if you want we can validate your logic in order to check what was the mistake?

Thanks.