Check if parent row has corresponding values

[UserBlue1973]

I have a table in an Excel 2016 spreadsheet that has hierarchical rows:

(Here's an Excel-friendly version that can be copied/pasted into a spreadsheet.)

ID	PARENT	UseWith1	UseWith2	UseWith3	UseWith-CheckParent
10		WORKORDER	SR
20	10	SR
30	10	WORKORDER	JOBPLAN
40	10	WORKORDER
50	40	WORKORDER	JOBPLAN	TOOLITEM

Question:

In column F, I want to flag child rows where the values in C, D, or E are missing from the parent row.

Example:

Is there a way to do this in Excel 2016?

[#2]

@UserBlue1973 refer attached file

[#3]

@bhushan_z Thanks, however, I can't download the .xlsm file due to security reasons.

Is there a reason why the file needs to be a .xlsm?

[#4]

@UserBlue1973 : even i m not sure it was saved as .xlsm, hahaha

here is new file in .xlsx 

Also refer below formula just for your reference.

=IF(B2="","",IF(AND(D2="",E2=""),"",IF(D2="","ERROR["&E2&" is missing from parent #"&B2&"]",IF(E2="","ERROR["&D2&" is missing from parent #"&B2&"]","ERROR["&D2&" and "&E2&" is missing from parent #"&B2&"]"))))

[#5]

@bhushan_z 

Thanks!

[#6]

Glad to help :)
If it works, pls marks above reply as "Official Answer" and we can close this thread.