If multiple cells in row have specific values, then give name to cell.

[Aproxcv]

Hello,

I really need help with one thing in excel 2016
Ill try to describe my problem:

I have big data file with columns from A to W

I am categorizing them and want to create a "derivative" column (if this is the correct term).

For example
If cell from column A1 contains value 1, and cell from H1 contains value "5 and random text", and cell k1 contains "random text" THEN put name on cell X1=category 1. (and i wish to create ~3 such categorys with different if's)

Does this kind of function IF exists in excel?

Have I described my problem clear enough?

 

[Special-K99]

in X1
=IF(AND(A1=1,H1="S and random text",K1="random text"),"Category 1","")

Base the other category names and IF requirements on the above

 

[Aproxcv]

in X1
=IF(AND(A1=1,H1="S and random text",K1="random text"),"Category 1","")

Base the other category names and IF requirements on the above

=IF(AND(A2=2,H2="1 = high"),"Category1",OR(A2=1,H2="0 & 3 = low alarm raised"),"category2",)

And i receive error message "too many arguments..." how to extend this, it looks like it should work.

 

[jtakw]

=IF(AND(A2=2,H2="1 = high"),"Category1",OR(A2=1,H2="0 & 3 = low alarm raised"),"category2",)

And i receive error message "too many arguments..." how to extend this, it looks like it should work.

Hi,

This is just to correct your formula above.
What do you mean by "5 and random text" and "random text" in you OP?

Book1
	A	H	X
2	2	1 = high	Category1
3	1	0 & 3 = low alarm raised	Category2
Sheet42

Cell Formulas
Range	Formula
X2	=IF(AND(A2=2,H2="1 = high"),"Category1",IF(OR(A2=1,H2="0 & 3 = low alarm raised"),"Category2",""))