IF nested query

[Deelof]

What's the best formula for the below criteria to return specific text as the Action column?

If "On Web" and Stock is less than or equal to 2 and Core or Non Core = "False", "Remove from Web"
And
If "On Web" and Stock is equal to 0 but Core or Non Core = "True", "Leave on Web"
And
If "Not on Web", stock is greater than 2 - "Data Checks"
And ignore any blanks in the Web Status column, returning a blank Action

WEB STATUS	CORE	NON CORE	STOCK	ACTION
ON WEB	FALSE	FALSE	2	REMOVE FROM WEB
ON WEB	FALSE	FALSE	5	LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	1	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	FALSE	0	REMOVE FROM WEB
ON WEB	FALSE	FALSE	10	LEAVE ON WEB
NOT ON WEB	FALSE	FALSE	32	DATA CHECKS
NOT ON WEB	FALSE	FALSE	20	DATA CHECKS
ON WEB	TRUE	FALSE	0	LEAVE ON WEB
ON WEB	FALSE	FALSE	6	LEAVE ON WEB
ON WEB	FALSE	FALSE	12	LEAVE ON WEB
ON WEB	FALSE	FALSE	7	LEAVE ON WEB
ON WEB	TRUE	FALSE	1	CORE - LEAVE ON WEB
ON WEB	TRUE	FALSE	9	CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB

 

[Deelof]

I understand your request as follows:

• If at least 1 TRUE, regardless of stock: Core or Noncore
• else, if stock <= 2: "Remove"
• else, if "NOT ON WEB", "Check", else, "Leave"
• In your explanation, there is no case for ("NOT ON WEB" and stock <= 2), so I assume it is "Remove" (stock <= 2).

Book1
	A	B	C	D	E
1	WEB STATUS	CORE	NON CORE	STOCK
2	ON WEB	FALSE	FALSE	2	Remove from Web
3	ON WEB	FALSE	FALSE	5	Leave on Web
4	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
5	ON WEB	FALSE	TRUE	1	Non Core -Leave on Web
6	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
7	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
8	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
9	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
10	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
11	ON WEB	FALSE	FALSE	0	Remove from Web
12	ON WEB	FALSE	FALSE	10	Leave on Web
13	NOT ON WEB	FALSE	FALSE	32	Date Checks
14	NOT ON WEB	FALSE	FALSE	20	Date Checks
15	ON WEB	FALSE	FALSE	3	Leave on Web
16	ON WEB	FALSE	FALSE	6	Leave on Web
17	ON WEB	FALSE	FALSE	12	Leave on Web
18	ON WEB	FALSE	FALSE	7	Leave on Web
19	ON WEB	TRUE	FALSE	1	Core - Leave on Web
20	ON WEB	TRUE	FALSE	9	Core - Leave on Web
21	ON WEB	FALSE	TRUE	0	Non Core -Leave on Web
Sheet1

Cell Formulas
Range	Formula
E2:E21	E2	=IFERROR(CHOOSE(MATCH(TRUE,B2:C2,0),"Core - ","Non Core -") & "Leave on Web",IF(D2<=2,"Remove from Web",IF(LEFT(A2,3)="NOT","Date Checks","Leave on Web")))

Thank you!
What if B and C hold vlookup as below to another tab and return blank, action result required here would be blank?

=IF($I4="","",IF(ISNA(VLOOKUP($I4,'Core & Core Non stock range'!$B:$G,5,FALSE)),"",VLOOKUP($I4,'Core & Core Non stock range'!$B:$G,5,FALSE)))

 

[Deelof]

What's the best formula for the below criteria to return specific text as the Action column?

If "On Web" and Stock is less than or equal to 2 and Core or Non Core = "False", "Remove from Web"
And
If "On Web" and Stock is equal to 0 but Core or Non Core = "True", "Leave on Web"
And
If "Not on Web", stock is greater than 2 - "Data Checks"
And ignore any blanks in the Web Status column, returning a blank Action

WEB STATUS	CORE	NON CORE	STOCK	ACTION
ON WEB	FALSE	FALSE	2	REMOVE FROM WEB
ON WEB	FALSE	FALSE	5	LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	1	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB
ON WEB	FALSE	FALSE	0	REMOVE FROM WEB
ON WEB	FALSE	FALSE	10	LEAVE ON WEB
NOT ON WEB	FALSE	FALSE	32	DATA CHECKS
NOT ON WEB	FALSE	FALSE	20	DATA CHECKS
ON WEB	TRUE	FALSE	0	LEAVE ON WEB
ON WEB	FALSE	FALSE	6	LEAVE ON WEB
ON WEB	FALSE	FALSE	12	LEAVE ON WEB
ON WEB	FALSE	FALSE	7	LEAVE ON WEB
ON WEB	TRUE	FALSE	1	CORE - LEAVE ON WEB
ON WEB	TRUE	FALSE	9	CORE - LEAVE ON WEB
ON WEB	FALSE	TRUE	0	NON CORE - LEAVE ON WEB

Further to this, how about if Core or Core Non Stock and Web Status = Not on Web? I'd like the Action response to be "Data" Checks".

If "On Web" and Stock is less than or equal to 2 and Core or Non Core = "False", "Remove from Web"
And
If "On Web" and Stock is equal to 0 but Core or Non Core = "True", "Leave on Web"
And
If "Not on Web", stock is greater than 2 - "Data Checks"
And ignore any blanks in the Web Status column, returning a blank Action