[Help]Comparing and populating status based on data availability on two fields(Multiple If Formula)

[scorpy]

Hi Guys, I am working on an excel file where I have 300k rows and 160 columns, In few places, I have to compare two nearby fields and populate the status on the third field(Status field) based on below mentioned rules. I would like a single formula(Multiple ifs?) to accomplish the same.


In the below-mentioned example Cell A denotes the first field, Cell B denotes the second field and Status denotes the third field where this formula should go.

• Status should be populated X if both Cell A and Cell B fields are blank.
• Status should be populated A if Cell A is blank and Cell B is populated with some value.
• Status should be populated D if Cell A is populated with some value and Cell B is blank.
• Status should be populated V if Cell A and Cell B have same values
• Status should be populated M if Cell A and Cell B have different values

Kindly help.

 

[shg]

	A​	B​	C​	D​
1​	​	​	Status​	​
2​	​	​	X​	C2: =CHOOSE(2*(A2 <> "") + (B2 <> "") + 1, "X", "A", "D", IF(A2 = B2, "V", "M"))
3​	​	1​	A​
4​	1​	​	D​
5​	1​	1​	V​
6​	1​	2​	M​

 

[scorpy]

Thanx a lot Bud

 

[shg]

Yer welcome.