Using IF condition to impute values from Two Columns

Question

I have a table that looks something like this in Google Sheets:

	A	B	C
2	Others	Maufacturing	Manufacturing
3	Manufacturing	MAnufacturing	Manufacturing
4	Others	Others	Others
5	Others		Others

I want to add a formula in column C that will return:

• IF A2="Others" return the value in B2. Since B2="Manufacturing" hence C2="Manufacturing"
• IF A3="Manufacturing" return the value in A3. Hence C3="Manufacturing"
• If A4="Others" and B4="Others" return B4. Hence C4="Others"
• If A5="Others" and B5=""returnA5. Hence C5="Others"`

There are 100s of unique values in column A.

I have tried the following formula:

=IFS(ISBLANK(A2), "",
     OR(A2="Manufacturing", A2="Manufacturer"),  "Manufacturing",
     OR(A2="Others", A2="Other"), "Others" )

Answer 1

There are various errors in your formula, including value's names. Try this:

=IFS( 
ISBLANK(A2),"", 
or( and (A2="Others", B2="Manufacturing"),and (A2="Manufacturing", B2="Manufacturing")),"Manufacturing", 
or( and (A2="Others", B2="Others"),A2 ="Others"), "Others" 
)

If you were to use it with the arrayformula() function you will have to eliminate the "and" and "or" like this:

=arrayformula(
IFS( 
ISBLANK(A2:A),"", 
(A2:A="Others")*(B2:B="Manufacturing"),"Manufacturing",
(A2:A="Manufacturing")*(B2:B="Manufacturing"),"Manufacturing", 
(A2:A="Others")*(B2:B="Others"),"Others", 
A2:A ="Others","Others" 
)
)

Answer 2

It seems like your goal is to return the first value <> "Others".

Try this in C2:

=ArrayFormula(if((A2:A="Others")*(B2:B<>""),B2:B,A2:A))