in a tangle with.... multiple-conditions-&-possibilities-for-multiple-ifs

[ellison]

Hi, I'm going around in circles trying to figure out how to do multiple IFS based on the contents of 2 cells.....
I'm not sure I've explained that very well, but hopefully this may help!

Sequence
1. If Col B is blank, do nothing, if not…
2. If Col C contains "alpha", return alpha into Column D
3. If Col C contains "beta", return beta into Column D
4. If Col C contains neither "alpha" nor "beta", return "not found" into Column D

mulltiple-conditions-&-possibilities-for-mutiple-ifs.xlsx
	A	B	C	D	E	F	G
1	Row	Info-1	Info-2	Goal	Reasoning		Sequence
2	2	3	text contains alpha	alpha	Col B is NOT blank, Col C contains alpha		1. If Col B is blank, do nothing, if not…
3	3		alpha		Col B is blank, so nothing		2. If Col C contains "alpha", return alpha
4	4	5	beta	beta	Col B is NOT blank, Col C contains beta		3. If Col C contains "beta", return beta
5	5		text contains beta		Col B is blank, so nothing		4. If Col C contains neither "alpha" or "beta", return "not found"
6	6	2		not found	Col B is NOT blank, Col C does NOT contain either alpha or beta
7	7				Col B is blank, so nothing
8	8	5	___ ALPHA ____	alpha	Col B is NOT blank, Col C contains alpha
9	9	8	____BETA____	beta	Col B is NOT blank, Col C contains beta
10	10		____BETA____		Col B is blank, so nothing
Sheet1

 

[Joe4]

Place this formula in cell D2 and copy down:

=IF(B2="","",IF(ISNUMBER(SEARCH("alpha",C2)),"alpha",IF(ISNUMBER(SEARCH("beta",C2)),"beta","not found")))

 

[Fluff]

How about

=IF(B2="","",IF(ISNUMBER(SEARCH("alpha",C2)),"alpha",IF(ISNUMBER(SEARCH("beta",C2)),"beta","Not found")))

 

[ellison]

Absolutely brilliant, thanks so much!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[BigBeachBananas]

-